Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Connection parameters and network protocol options » Connection parameters


CharSet connection parameter [CS]

Specifies the character set to be used on this connection.






The local character set.

For more information about how the local character set is determined, see Determining locale information.


If you supply a value for CharSet, the specified character set is used for the current connection. Setting CharSet=none disables character set conversion for the connection.

When unloading data, you can specify the character set using the CharSet connection parameter. For more information about valid character set values, see Recommended character sets and collations.

In order to avoid lossy character set conversions, setting the CHARSET connection parameter is not recommended when using Unicode client APIs. Unicode client APIs include ADO.NET, OLE DB, and the iAnywhere JDBC driver. ODBC is also a Unicode client API when the wide (Unicode) functions are used.

See also