DisableUnicode

Description

Specifies whether data is retrieved from the database as ANSI or Unicode. Use this parameter if the client is configured to use a character set that does not allow characters such as the Euro symbol to be converted correctly.

Applies to

O84 Oracle 8.x and Oracle8i

Syntax

DisableUnicode = value

Parameter	Description
value	Specifies whether data is retrieved from the database as ANSI or Unicode. Values are: 0 PowerBuilder retrieves data as Unicode. 1 PowerBuilder retrieves data as ANSI.

Parameter

Description

value

Specifies whether data is retrieved from the database as ANSI or Unicode. Values are:

0 PowerBuilder retrieves data as Unicode.
1 PowerBuilder retrieves data as ANSI.

Default

DisableUnicode =0

Usage

When the client is configured to use a character set such as WE8ISO8859P15, some special characters, including the Euro symbol, are not converted correctly when retrieved from an Oracle8i database. The O84 driver retrieves Unicode characters from the database by default, and the Euro symbol is not recognized as a valid Unicode character in this character set.

You can set the DisableUnicode database parameter to retrieve ANSI characters from the database instead of Unicode characters. The retrieved ANSI characters are then converted to a Unicode string.

Examples

Example 1

To specify that PowerBuilder should retrieve ANSI characters from the database:

Database profile Select the Disable Unicode Support check box on the Connection page in the Database Profile Setup dialog box for Oracle8i.
Application Type the following in code:
```
SQLCA.DBParm = "DisableUnicode=1"
```