Determines how ANSI character strings are translated.
Valid Values
yes | no
Behavior
If set to yes (Enabled), ANSI character strings sent between the client and server are translated by converting through Unicode to minimize problems in matching extended characters between the code pages on the client and the server.
These conversions are performed on the client by the SQL Server Legacy Wire Protocol driver. This requires that the same ANSI code page (ACP) used on the server be available on the client.
These settings have no effect on the conversions that occur for the following transfers:
Unicode SQL_C_WCHAR client data sent to char, varchar, or text on the server.
Char, varchar, or text server data sent to a Unicode SQL_C_WCHAR variable on the client.
ANSI SQL_C_CHAR client data sent to Unicode nchar, nvarchar, or ntext on the server.
Unicode char, varchar, or text server data sent to an ANSI SQL_C_CHAR variable on the client.
If set to no (Disabled), character translation is not performed.
The SQL Server Legacy Wire Protocol driver does not translate client ANSI character SQL_C_CHAR data sent to char, varchar, or text variables, parameters, or columns on the server. No translation is performed on char, varchar, or text data sent from the server to SQL_C_CHAR variables on the client. If the client and Microsoft SQL Server are using different ACPs, then extended characters can be misinterpreted.
Unicode SQL_C_WCHAR client data sent to char, varchar, or text on the server.