NumbersInternal
database parameter
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
|
1 |
NumbersInternal=value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies that numbers should be retrieved using
|
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:
1SQLCA.DBParm="NumbersInternal=1"