Datatype Mappings for ODBC Subscribers

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