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.
O90 Oracle9i
O10 Oracle 10g
ORA Oracle 11g
NumbersInternal=value
Parameter |
Description |
|---|---|
value |
Specifies that numbers should be retrieved using Oracle’s internal 21-byte binary NUMBER datatype format. Values are:
|
NumbersInternal=0
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.
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"
