LucidDbBcpTypeToSqlType

From Eigenpedia

Jump to: navigation, search
BCP data type LucidDb data type
SQLCHAR CHAR
SQLNCHAR CHAR
SQLVARCHAR VARCHAR
SQLBINARY BINARY
SQLVARBINARY VARBINARY
SQLDATE DATE
SQLDATETIME TIMESTAMP
SQLDATETIM4 TIMESTAMP
SQLTIME TIME
SQLTIMESTAMP TIMESTAMP
SQLDECIMAL DECIMAL
SQLNUMERIC DECIMAL
SQLINT INTEGER
SQLBIGINT BIGINT
SQLSMALLINT SMALLINT
SQLTINYINT TINYINT
SQLMONEY DECIMAL
SQLMONEY4 DECIMAL
SQLREAL REAL
SQLFLT4 FLOAT
SQLFLT8 DOUBLE
SQLBIT BOOLEAN
SQLUNIQUEID VARCHAR
SQLVARIANT BINARY
SQLUDT VARCHAR
anything else VARCHAR