Datatypes

The classes RWDBColumn and RWDBValue have an associated RWDBValue::ValueType that specifies the datatype of the database column or field being referenced. Mapping between this datatype and the database vendor type runs in both directions:

When fetching data or retrieving information about tables, the DB Access Module for Oracle OCI converts the Oracle-specific datatype information provided by the database into RWDBValue::ValueTypes. This mapping is shown in the table Type mapping when retrieving data, which also gives the C++ datatype corresponding to the RWDBValue::ValueType.
When creating tables, the DB Access Module for Oracle OCI maps the given RWDBValue::ValueType into an Oracle-specific type. This mapping is shown in the table Type mapping when creating tables.

The RWDBValue::ValueType, accessible through the type() method, is uniform across all Access Modules. For a complete explanation of the DB Interface Module data model, see The Data Model and RWDBValue in the SourcePro API Reference.

Type mapping when retrieving data
Oracle Datatype	RWDBValue::ValueType	C++ Datatype
`CHAR(n)` `VARCHAR2(n)`	`String`	RWCString
`NCHAR(n)` `NVARCHAR2(n)`	`UString`	RWBasicUString or RWUString
`LONG`	`String`	RWCString
`CLOB`	`String`	RWCString
`RAW(n)` `LONG RAW`	`Blob`	RWDBBlob
`BLOB`	`Blob`	RWDBBlob
`NUMBER(p,0) 0 < p < 10`¹	`Long`	`long int`
`NUMBER(p,0) 10 <= p < 19`¹	`LongLong`	`long long`
`NUMBER(p,0) p >= 19`	`Decimal`	RWDecimalPortable
`NUMBER(p,s) 0 < p < 10`¹	`Double`	`double`
`NUMBER(p,s) p >= 10`	`Decimal`	RWDecimalPortable
`NUMBER`	`Decimal`	RWDecimalPortable
`FLOAT(p)`	`Double`	`double`
`BINARY_FLOAT`	`Float`	`float`
`BINARY_DOUBLE`	`Double`	`double`
`DATE`²	`DateTime`	RWDateTime
`ROWID`	`String`	RWCString
`MLSLABEL`	`String`	RWCString
`TIMESTAMP`² ³	`DateTime`	RWDateTime

Type mapping when creating tables
RWDBValue::ValueType	Oracle Datatype
`Blob`	`BLOB`, if `nativeType` of the RWDBColumn is `SQLT_BLOB` `RAW(n)`, using the `storageLength` of the RWDBColumn for value `n`, if 0 < `storageLength` <= 2000 `LONG RAW` otherwise
`Char` `UnsignedChar`	`NUMBER(d)`, where `d` is the number of digits needed to store the maximum value a `char` can express on the client machine
`Date`	`DATE`
`DateTime`	`DATE` if `useTimestamp()` is `false`⁴ `TIMESTAMP(p)`, using `precision` of RWDBColumn, if `useTimestamp()` is `true` and `precision` is specified `TIMESTAMP` otherwise
`Decimal`	`NUMBER(p,s)`, using `precision` and `scale` of RWDBColumn if precision is specified `NUMBER` otherwise
`Double`	`FLOAT(126)`
`Duration`	Not supported by DB Access Module for Oracle OCI.
`Float`	`FLOAT(p)` using `precision` of RWDBColumn, if specified. `FLOAT` otherwise
`Int` `UnsignedInt`	`NUMBER(d)`, where `d` is the number of digits needed to store the maximum value an `int` can express on the client machine
`Long` `UnsignedLong`	`NUMBER(d)`, where `d` is the number of digits needed to store the maximum value a `long` can express on the client machine
`LongLong` `UnsignedLongLong`	`NUMBER(d)` where `d` is the number of digits needed to store the maximum value a `long long` can express on the client machine
`MBString` `UString` `WString`	`NVARCHAR2(n)` using the `storageLength` of the RWDBColumn, if specified `NVARCHAR2(2000)` otherwise
`Short` `UnsignedShort` `Tiny` `UnsignedTiny`	`NUMBER(d)`, where `d` is the number of digits needed to store the maximum value a `short` can express on the client machine
`String`	`CLOB`, if `nativeType` of the RWDBColumn is `SQLT_CLOB` `VARCHAR2(n)`, using the `storageLength` of the RWDBColumn, if 0 < `storageLength` <= 4000 `LONG` otherwise
`NoType`	If `nativeType` of the RWDBColumn is: `SQLT_NUM`, then `NUMBER(p,s)`, using `precision` and `scale` of the RWDBColumn `SQLT_RDD`, then `ROWID` `SQLT_BFLOAT` or `SQLT_IBFLOAT`, then `BINARY_FLOAT` `SQLT_BDOUBLE` or `SQLT_IBDOUBLE`, then `BINARY_DOUBLE`

In this section: