UTF8 database parameter
Description
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 PowerBuilder.
Controls
-
ASE, SYC and SYJ Sybase
Adaptive Server Enterprise -
DIR Sybase DirectConnect
Syntax
|
1 |
UTF8=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether the database server
|
Default
UTF8=0
Usage
If UTF8 is set to 1, PowerBuilder 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:
|
1 |
sp_configure "enable Unicode conversion", 2 |
This enables the server to perform the conversion to and from
Unicode.
Examples
To specify that the database server you are accessing
with PowerBuilder 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:
1SQLCA.DbParameter="UTF8=1"