| SQL Server Type | CRDB Type |
|---|---|
| bigint | bigint |
| numeric | numeric |
| bit | boolean |
| smallint | smallint |
| decimal | decimal |
| smallmoney | decimal(9,2) |
| int | int |
| tinyint | smallint |
| money | decimal(9,2) |
| double precision | double precision |
| float | float |
| real | real |
| date | date |
| datetimeoffset | timestamp with time zone, timestamptz |
| datetime | timestamp(3) |
| datetime2 | timestamp |
| smalldatetime | timestamp(0) |
| time | time |
| char | char |
| varchar | varchar |
| varchar(max) | text |
| text | text |
| nchar | char |
| nvarchar | varchar |
| nvarchar(max) | text |
| ntext | text |
| binary | bytea |
| varbinary | bytea |
| image | bytea |
| uniqueidentifier | uuid |
| xml | jsonb |
| Spatial Geometry Types | geometry |
| Spatial Geography Types | geography |
| cursor | n/a |
| rowversion | n/a |
| hierarchyid | n/a |
| sql_variant | n/a |
| table | n/a |