Microsoft® SQL Server™ includes an ODBC driver that supports SQL Server 6.5 subscriptions to SQL Server 7.0 publications. The ODBC driver exists only for Intel® computers. SQL Server Setup installs the driver automatically.
The following table maps SQL Server 7.0 data types to SQL Server 6.5 data types. When you replicate to ODBC Subscribers, the distribution task maps SQL Server data types to the closest data type on the target database.
| SQL Server data type | SQL Server 6.5 data type |
|---|---|
| binary | BINARY (255) NOT NULL |
| char | CHAR (255) NOT NULL |
| datetime | DATETIME NOT NULL |
| decimal | DECIMAL (28, 14) NOT NULL |
| float | FLOAT NOT NULL |
| image | IMAGE NULL |
| int | INT NOT NULL |
| int | INT NOT NULL |
| moneycold | MONEY NOT NULL |
| money4col | SMALLMONEY NOT NULL |
| tinyint | TINYINT NOT NULL |
| ntext | NTEXT NULL |
| numeric | NUMERIC (28, 14) NOT NULL |
| real | REAL NOT NULL |
| smalldatetime | SMALLDATETIME NOT NULL |
| smallint | SMALLINT NOT NULL |
| text | TEXT NULL |
| timestamp | BINARY (8) NULL |
| vbinary | VARBINARY (255) NOT NULL |
| vchar | VARCHAR (255) NOT NULL |