Code page client uses to display PROMSGS from the server

To display PROMSGS from the server, the client uses the code page set by SQL_CLIENT_CHARSET_PROMSGS, if you have set this environment variable. Or, the client uses the code page set by SQL_CLIENT_CHARSET, if you have set this environment variable. If you have set neither of these environment variables, then the client uses the code page of the client's operating system.

If you want run-time messages at the SQL client to use a different code page from either the client operating system or the code page set by SQL_CLIENT_CHARSET, you can set the SQL_CLIENT_CHARSET_PROMSGS environment variable. When you set this variable to a code page, the SQL server converts run-time messages that are sent from the server to the client to the code page set by SQL_CLIENT_CHARSET_PROMSGS.