UTF8 – PB Docs 126

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.

note.png When to specify UTF8

You must specify a value for UTF8 before connecting
to the database in PowerBuilder.

Controls

  • ASE, SYC and SYJ SAP
    Adaptive Server Enterprise

  • DIR Sybase DirectConnect

Syntax

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:

  • 0

    (Default) The PowerBuilder database interface
    performs the conversion. Multiple languages are not supported.

  • 1

    Your database server performs the conversion. Multiple languages
    are supported.

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:

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:


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x