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.
Applies to
ASE and SYC SAP Adaptive Server Enterprise
DIR SAP DirectConnect
Syntax
UTF8=value
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether the database server you are accessing will perform conversion between the character sets used on the client and server. Values are:
|
Default value
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:
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:
SQLCA.DBParm="UTF8=1"
