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.
Applies to
ASE and SYC SAP Adaptive Server Enterprise
DIR SAP DirectConnect
Syntax
|
1 |
UTF8=value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether the database server you 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:
|
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.DBParm="UTF8=1"