Specifies the character set you want the Sybase Open Client™ software to use when connecting to a Sybase Adaptive Server Enterprise database or a database accessed through DirectConnect.
ASE, SYC Sybase Adaptive Server Enterprise
DIR Sybase DirectConnect
CharSet='character_set'
None
When you specify a value for CharSet, PowerBuilder:
Allocates a CS_LOCALE structure for this connection
Sets the CS_SYB_CHARSET value to the character set you specify
Sets the SQL Server CS_LOC_PROP connection property with the new locale information
Overriding the Locale parameter If you have previously set a value for the Locale parameter that includes settings for the language and character set you want to use, you can override the character set value by specifying a new value for the CharSet parameter and reconnecting to the database.
Unicode data access PowerBuilder can access Unicode data in an Adaptive Server Enterprise (ASE) 12.5 or later Unicode database or in Unicode columns in ASE 12.5 or later. PowerBuilder converts between double-byte character set (DBCS) data and Unicode automatically, provided that the CharSet and Language parameters are set with DBCS values (or the Locale parameter is set with DBCS values). For example:
CharSet='big5'
Language='tchinese'
To set the character set to iso_1:
Database profile Type the following in the Character Set box on the Connection page or Regional Settings page in the Database Profile Setup dialog box:
iso_1
Application Type the following in code:
SQLCA.DBParm="CharSet='iso_1'"
