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.
Controls
-
O90 Oracle9i
-
O10 Oracle 10g
-
ORA Oracle 11g
Syntax
|
1 |
NumbersInternal=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
Specifies that numbers should be retrieved
|
Default
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.DbParameter="NumbersInternal=1"