神通数据库支持的数据类型转换特性¶
神通数据库支持的数据类型转换特性可以通过查询系统视图 v_sys_conversion_info 获取， 具体取值如下:
| 转换类型名 | 转换特性值 | 描述 |
|---|---|---|
| CONVERT_BIGINT | 64958 | An int bitmask. The bitmask indicates the conversions supported by the data source with theCONVERT scalar function for data of the type named in the InfoType. If the bitmask equals zero, the data source doesnot support any conversions from data of the named type, including conversionto the same data type.(SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT: 0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR:0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT:0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_BINARY | 25624 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_BIT | 20488 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_CHAR | 1 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_DATE | 131072 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_DECIMAL | 24830 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_DOUBLE | 24830 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_FLOAT | 24830 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_INTEGER | 25854 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_INTERVAL_DAY_TIME | 0 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_INTERVAL_YEAR_MONTH | 0 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_LONGVARBINARY | 0 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_LONGVARCHAR | 0 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_NUMERIC | 8446 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_REAL | 24830 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_SMALLINT | 27902 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_TIME | 131072 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_TIMESTAMP | 32768 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_TINYINT | 27902 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_VARBINARY | 26648 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |
| CONVERT_VARCHAR | 256 | (SQL_CVT_CHAR:0x00000001L,SQL_CVT_NUMERIC:0x00000002L,SQL_CVT_DECIMAL: 0x00000004L,SQL_CVT_INTEGER: 0x00000008L, SQL_CVT_SMALLINT:0x00000010L,SQL_CVT_FLOAT:0x00000020L,SQL_CVT_REAL:0x00000040L,SQL_CVT_DOUBLE:0x00000080L,SQL_CVT_VARCHAR: 0x00000100L,SQL_CVT_LONGVARCHAR: 0x00000200L,SQL_CVT_BINARY:0x00000400L,SQL_CVT_VARBINARY:0x00000800L,SQL_CVT_BIT:0x00001000L,SQL_CVT_TINYINT: 0x00002000L,SQL_CVT_BIGINT: 0x00004000L,SQL_CVT_DATE: 0x00008000L,SQL_CVT_TIME: 0x00010000L,SQL_CVT_TIMESTAMP: 0x00020000L,SQL_CVT_LONGVARBINARY: 0x00040000L,SQL_CVT_INTERVAL_YEAR_MONTH: 0x00080000L,SQL_CVT_INTERVAL_DAY_TIME: 0x00100000L,SQL_CVT_GUID: 0x01000000L) |