To display database data from the server, the client uses the code page set by SQL_CLIENT_CHARSET, if you have set this environment variable on the client machine. Otherwise, the client uses the code page of the client's operating system.
If you want to specify an SQL client code page that is different from the client operating system, you can set the SQL_CLIENT_CHARSET environment variable to the name of a Progress code page. When you set this variable to a code page, the SQL server converts text data that is sent from the server to the client to the code page set by SQL_CLIENT_CHARSET. The server also uses this code page when it converts text data that is sent from the client to the server to the server code page.
