The UTF8 database parameter specifies whether the database server you are accessing will handle conversion between the character sets on the client and server when they are different.
When to specify UTF8
You must specify a value for UTF8 before connecting
to the database in DataWindow Designer.
ASE, SYC Sybase Adaptive Server Enterprise
DIR Sybase DirectConnect
UTF8=value
UTF8=0
If UTF8 is set to 1, DataWindow Designer always uses UTF-8 as the client character set when connecting to an Adaptive Server database. When UTF8 is set to 0, if the client and database server character sets are different, the database interface converts Transact-SQL, identifiers, parameters, and Char and VarChar data to and from the character set used on the server. Multiple languages are not supported with this setting.
To enable multilanguage support, you must set the UTF8 database parameter to 1 and the database server must have the UTF-8 character set installed, or, for Adaptive Server, it must be configured to support Unicode conversions. To do so, the database administrator must run the following command on the server:
sp_configure "enable Unicode conversion", 2
This enables the server to perform the conversion to and from Unicode.
To specify that the database server you are accessing with DataWindow Designer uses UTF-8 as its default character set:
Database profile Select the UTF8 Character Set Installed or Unicode Conversion Enabled check box on the Regional Settings page in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DbParameter="UTF8=1"
