HomePowerBuilderAppeon Documentation Center

NumbersInternal

Description

Specifies that numbers should be retrieved from the database using Oracle's internal 21-byte binary NUMBER datatype format instead of using OCI strings. The NumbersInternal parameter is relevant only when you are accessing an Oracle database configured with an EBCDIC character set or other non-ASCII character set.

When to specify NumbersInternal

You must specify the NumbersInternal parameter before connecting to the database.

Applies to

O90 Oracle9i

O10 Oracle 10g

ORA Oracle (for 11g and later)

Syntax

NumbersInternal=value

Parameter

Description

value

Specifies that numbers should be retrieved using Oracle's internal 21-byte binary NUMBER datatype format. Values are:

  • 0

    (Default) Do not retrieve numbers in internal format.

  • 1

    Retrieve numbers in internal format.

Default value

NumbersInternal=0

Usage

In addition to specifying that numbers be retrieved from the database using Oracle's internal 21-byte binary NUMBER datatype format, the NumbersInternal parameter also provides an internal algorithm for deciphering the result.

Examples

To specify that you want numbers to be retrieved using Oracle's internal format:

  • Database profile

    Select the Retrieve Numbers in Internal Format check box on the Syntax page in the Database Profile Setup dialog box.

  • Application

    Type the following in code:

    SQLCA.DBParm="NumbersInternal=1"
Prev  Up  Next
NLS_Charset  Home  NumericFormat