The ESL character data type is:
EDS_STRING
The following table shows the SQL data types to which the EDS_STRING data type may be converted. For an explanation of the columns and terms in the table, see Converting Data from ESL to SQL Data Types.
SQLTYPE |
Test |
SQL STATE |
EDS_SQL_CHAR EDS_SQL_VARCHAR EDS_SQL_LONGVARCHAR |
Length of data ≤ Column length. |
00000 |
Length of data > Column length |
22001 |
|
EDS_SQL_DECIMAL EDS_SQL_NUMERIC EDS_SQL_BIT EDS_SQL_TINYINT EDS_SQL_SMALLINT EDS_SQL_INTEGER EDS_SQL_BIGINT EDS_SQL_REAL EDS_SQL_FLOAT EDS_SQL_DOUBLE |
Data converted without truncation. |
00000 |
Data converted with truncation, but without loss of significant digits. |
22001 |
|
Conversion of data would result in loss of significant digits. |
22003 |
|
Data value is not a numeric value. |
22005 |
|
EDS_SQL_BINARY EDS_SQL_VARBINARY EDS_SQL_LONGVARBINARY |
Length of data ≤ Column length. |
00000 |
Length of data > Column length. |
22001 |
|
EDS_SQL_DATE |
Data value is a valid date |
00000 |
Data value is not a valid date. |
22008 |
|
EDS_SQL_TIME |
Data value is a valid time. |
00000 |
Data value is not a valid time. |
22008 |
|
EDS_SQL_TIMESTAMP |
Data value is a valid timestamp. |
00000 |
Data value is not a valid timestamp. |
22008 |
When ESL character data is converted to binary SQL data, each two bytes of character data are converted to a single byte (8 bits) of binary data. Each two bytes of character data represent a number in hexadecimal form. For example, “01” is converted to a binary 00000001 and “FF” is converted to a binary 11111111.
