Specifies the character set to be used on this connection.

Usage

Anywhere

Values

String

Default

The local character set.

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

Remarks

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

• How connection parameters work
• Connection parameter tips
• SACHARSET environment variable
• Understanding the locale character set