CharSet connection parameter [CS]

Function

To specify the character set to be used on this connection.

Usage

Anywhere

Default

The locale character set. For information on how this is determined, see “Determining locale information”.

Description

If you supply a value for CharSet, the specified character set is used for the current connection. 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 on valid character set values, see “Setting locales”.

To avoid lossy character set conversions, Sybase recommends against setting the CharSet connection parameter 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

“How connection parameters work”