When replicating to ODBC subscribers, the distribution task maps SQL Server datatypes to the closest datatype on the target database. The following table shows the datatype mappings for replication to Microsoft Access subscribers.
SQL Server datatype | Maps to Microsoft Jet datatype |
---|---|
bit | BIT |
tinyint | BYTE |
image | LONGBINARY |
varbinary | VARBINARY |
binary | BINARY |
timestamp | BINARY |
text | LONGTEXT |
char | CHAR |
numeric | CHAR |
decimal | CHAR |
money | CHAR |
smallmoney | DOUBLE |
int | LONG |
smallint | SHORT |
float | DOUBLE |
real | SINGLE |
datetime | CHAR |
smalldatetime | DATETIME |
varchar | VARCHAR2 |
The following table shows the datatype mappings for replication to ORACLE subscribers.
SQL Server datatype | Maps to ORACLE datatype |
---|---|
bit | NUMBER |
tinyint | NUMBER |
image | LONG RAW |
varbinary | RAW |
binary | RAW |
timestamp | RAW |
text | LONG |
char | CHAR |
numeric | NUMBER |
decimal | NUMBER |
money | NUMBER |
smallmoney | NUMBER |
int | NUMBER |
smallint | NUMBER |
float | FLOAT |
real | FLOAT |
datetime | CHAR |
smalldatetime | DATE |
varchar | VARCHAR2 |