Oracle® Database Gateway for SQL Server User's Guide, 11g Release 2 (11.2) Part Number E12069-01 |
|
|
PDF · Mobi · ePub |
This appendix contains the following section:
The gateway converts SQL Server data types to Oracle data types as follows:
Table A-1 Data Type Conversions
SQL Server | Oracle | Comment |
---|---|---|
|
|
|
- |
||
|
- |
|
|
- |
|
Fractional parts of a second are truncated |
||
|
- |
|
|
|
|
|
- |
|
- |
||
|
|
|
|
|
|
|
- |
|
|
if the size is 1000 or less. If the size is more than 1000, then it will be mapped to |
|
|
|
if Oracle DB Character Set = Unicode. Otherwise, it is not supported |
|
- |
|
|
|
if Oracle DB Character Set = Unicode. Otherwise, it is not supported |
|
- |
|
|
|
|
|
- |
|
|
- |
|
|
- |
|
|
- |
|
|
|
|
|
|
- |
|
|
|
|
- |
|
|
- |
|
|
|
|
|
- |
|
|
|
|
|
- |
|
|
- |
|
|
|
if Oracle Database Character Set = Unicode. Otherwise, it is not supported. |