The character set of Oracle client and ODAC

1.pl/sql Developer 9 Check whether the client character set is consistent with the server

Preferences, options, check whether the client and server character sets match

Changes to 2.Windows environment variables take effect immediately

3.ODAC12 change of character set after installation

Use SELECT * from Sys.nls_session_parameters;

Simplified Chinese, the difference between American.

4. Adjust environment variables Oracle CLIENT11GR2 and ODAC12 solve Chinese character query problems in sequence

After loading the ODAC in the environment variable in front:

Adjust to:

C:\app\Administrator\product\11.2.0\client_1\bin; C:\app\client\Administrator\product\12.1.0\client_1; C:\app\client\Administrator\product\12.1.0\client_1\bin; %systemroot%\system32;%systemroot%;%systemroot%\system32\wbem;%systemroot%\system32\windowspowershell\v1.0\; C:\Program Files (x86) \microsoft SQL server\100\tools\binn\; C:\Program Files\Microsoft SQL Server\100\tools\binn\; C:\Program Files\Microsoft SQL Server\100\dts\binn\

The character set of Oracle client and ODAC