SQL Server data type => ODBC data type => Haskell data type
(default of HDBC-odbc)
[o] image -- SQL_LONGVARBINARY -- ByteString
[o] text -- SQL_LONGVARCHAR -- ByteString
[ ] uniqueidentifier -- SQL_GUID
[o] date -- SQL_TYPE_DATE -- Day
[ ] time -- SQL_SS_TIME2 (-154)
[o] " -- SQL_TYPE_TIME -- TimeOfDay
[o] datetime2 -- SQL_TYPE_TIMESTAMP -- LocalTime
[ ] datetimeoffset -- SQL_SS_TIMESTAMPOFFSET (-155)
[o] tinyint -- SQL_TINYINT -- Char
[o] smallint -- SQL_SMALLINT -- Int32
[o] int -- SQL_INTEGER -- Int32
[o] smalldatetime -- SQL_TYPE_TIMESTAMP -- LocalTime
[o] real -- SQL_REAL -- Double
[ ] money -- SQL_DECIMAL -- ByteString
[o] datetime -- SQL_TYPE_TIMESTAMP -- LocalTime
[o] float -- SQL_DOUBLE -- Double
[ ] sql_variant
[o] ntext -- SQL_WLONGVARCHAR -- ByteString
[o] bit -- SQL_BIT -- Char
[o] decimal -- SQL_DECIMAL -- ByteString
[o] numeric -- SQL_NUMERIC -- ByteString
[ ] smallmoney -- SQL_DECIMAL?
[o] bigint -- SQL_BIGINT -- Int64
[o] varbinary -- SQL_VARBINARY -- ByteString
[o] varchar -- SQL_VARCHAR -- ByteString
[o] binary -- SQL_BINARY -- ByteString
[o] char -- SQL_CHAR -- ByteString
[o] timestamp -- SQL_TYPE_TIMESTAMP -- LocalTime
[o] nvarchar -- SQL_WVARCHAR -- ByteString
[o] sysname -- SQL_WVARCHAR -- ByteString
[o] nchar -- SQL_WCHAR -- ByteString
[ ] hierarchyid
[ ] geometry
[ ] geography
[ ] xml
Last active
December 17, 2015 16:59
-
-
Save yuga/5642957 to your computer and use it in GitHub Desktop.
Data type mapping.
Maybe like this...
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment