| ASCII | UTF8 | UCS2 | ASCII_CLOB | UTF8_CLOB | UCS2_CLOB | BINARY | BLOB | |
| CHAR() |
|
|
|
|
|
|
|
|
| VARCHAR() |
|
|
|
|
|
|
|
|
| CHAR() UNICODE |
|
|
|
|
|
|
|
|
| VARCHAR() UNICODE |
|
|
|
|
|
|
|
|
| LONG |
|
|
|
|
|
|
|
|
| LONG UNICODE |
|
|
|
|
|
|
|
|
| CHAR() BYTE |
|
|
|
|
|
|
|
|
| VARCHAR() BYTE |
|
|
|
|
|
|
|
|
| LONG BYTE |
|
|
|
|
|
|
|
|
| FIXED |
|
|
|
|
|
|
|
|
| INTEGER |
|
|
|
|
|
|
|
|
| SMALLINT |
|
|
|
|
|
|
|
|
| FLOAT |
|
|
|
|
|
|
|
|
| REAL |
|
|
|
|
|
|
|
|
| DOUBLE PRECISION |
|
|
|
|
|
|
|
|
| DATE |
|
|
|
|
|
|
|
|
| TIME |
|
|
|
|
|
|
|
|
| TIMESTAMP |
|
|
|
|
|
|
|
|
| BOOLEAN |
|
|
|
|
|
|
|
|
|
supported |
|
unsupported |
| [U]INT1 | [U]INT2 | [U]INT4 | [U]INT8 | DOUBLE | FLOAT | DECIMAL | ODBCNUMERIC | |
| CHAR() |
|
|
|
|
|
|
|
|
| VARCHAR() |
|
|
|
|
|
|
|
|
| CHAR() UNICODE |
|
|
|
|
|
|
|
|
| VARCHAR() UNICODE |
|
|
|
|
|
|
|
|
| LONG |
|
|
|
|
|
|
|
|
| LONG UNICODE |
|
|
|
|
|
|
|
|
| CHAR() BYTE |
|
|
|
|
|
|
|
|
| VARCHAR() BYTE |
|
|
|
|
|
|
|
|
| LONG BYTE |
|
|
|
|
|
|
|
|
| FIXED |
|
|
|
|
|
|
|
|
| INTEGER |
|
|
|
|
|
|
|
|
| SMALLINT |
|
|
|
|
|
|
|
|
| FLOAT |
|
|
|
|
|
|
|
|
| REAL |
|
|
|
|
|
|
|
|
| DOUBLE PRECISION |
|
|
|
|
|
|
|
|
| DATE |
|
|
|
|
|
|
|
|
| TIME |
|
|
|
|
|
|
|
|
| TIMESTAMP |
|
|
|
|
|
|
|
|
| BOOLEAN |
|
|
|
|
|
|
|
|
| ODBCDATE | ODBCTIME | ODBCTIMESTAMP | |
| CHAR() |
|
|
|
| VARCHAR() |
|
|
|
| CHAR() UNICODE |
|
|
|
| VARCHAR() UNICODE |
|
|
|
| LONG |
|
|
|
| LONG UNICODE |
|
|
|
| CHAR() BYTE |
|
|
|
| VARCHAR() BYTE |
|
|
|
| LONG BYTE |
|
|
|
| FIXED |
|
|
|
| INTEGER |
|
|
|
| SMALLINT |
|
|
|
| FLOAT |
|
|
|
| REAL |
|
|
|
| DOUBLE PRECISION |
|
|
|
| DATE |
|
|
|
| TIME |
|
|
|
| TIMESTAMP |
|
|
|
| BOOLEAN |
|
|
|