An enumeration of the native types of values as described by the server.
public enum a_sqlany_native_type
Member name | Description |
---|---|
DT_NOTYPE |
No data type. |
DT_DATE |
Null-terminated character string that is a valid date. |
DT_TIME |
Null-terminated character string that is a valid time. |
DT_TIMESTAMP |
Null-terminated character string that is a valid timestamp. |
DT_VARCHAR |
Varying length character string, in the CHAR character set, with a two-byte length field. The maximum length is 32765 bytes. When sending data, you must set the length field. When fetching data, the database server sets the length field. The data is not null-terminated or blank-padded. |
DT_FIXCHAR |
Fixed-length blank-padded character string, in the CHAR character set. The maximum length, specified in bytes, is 32767. The data is not null-terminated. |
DT_LONGVARCHAR |
Long varying length character string, in the CHAR character set. |
DT_STRING |
Null-terminated character string, in the CHAR character set. The string is blank-padded if the database is initialized with blank-padded strings. |
DT_DOUBLE |
8-byte floating-point number. |
DT_FLOAT |
4-byte floating-point number. |
DT_DECIMAL |
Packed decimal number (proprietary format). |
DT_INT |
32-bit signed integer. |
DT_SMALLINT |
16-bit signed integer. |
DT_BINARY |
Varying length binary data with a two-byte length field. The maximum length is 32765 bytes. When supplying information to the database server, you must set the length field. When fetching information from the database server, the server sets the length field. |
DT_LONGBINARY |
Long binary data. |
DT_TINYINT |
8-bit signed integer. |
DT_BIGINT |
64-bit signed integer. |
DT_UNSINT |
32-bit unsigned integer. |
DT_UNSSMALLINT |
16-bit unsigned integer. |
DT_UNSBIGINT |
64-bit unsigned integer. |
DT_BIT |
8-bit signed integer. |
DT_LONGNVARCHAR |
Long varying length character string, in the NCHAR character set. |
The value types correspond to the embedded SQL data types. For more information on embedded SQL data types, see Embedded SQL data types.
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |