LucidDbBcpTypeToSqlType
From LucidDB Wiki
| 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 |
