The following table indicates the values of the length field when you retrieve data from the database using a SQLDA. The sqllen field is never modified when you retrieve data.
Only the interface data types displayed in the table are allowed in this case. The DT_DATE, DT_TIME, and DT_TIMESTAMP data types are treated the same as DT_STRING when you retrieve information from the database. The value is formatted as a character string in the current date format.
Embedded SQL data type | What the program must set length field to when receiving | How the database returns length information after fetching a value |
---|---|---|
DT_BIGINT | No action required. | No action required. |
DT_BINARY(n) | Maximum length of BINARY structure (n+2). The maximum value for n is 32765. | len field of BINARY structure set to actual length in bytes. |
DT_BIT | No action required. | No action required. |
DT_DATE | Length of buffer. | null character at end of string. |
DT_DOUBLE | No action required. | No action required. |
DT_FIXCHAR(n) | Length of buffer, in bytes. The maximum value for n is 32767. | Padded with blanks to length of buffer. |
DT_FLOAT | No action required. | No action required. |
DT_INT | No action required. | No action required. |
DT_LONGBINARY | Length field ignored. | Length field ignored. |
DT_LONGNVARCHAR | Length field ignored. | Length field ignored. |
DT_LONGVARCHAR | Length field ignored. | Length field ignored. |
DT_NFIXCHAR(n) | Length of buffer, in bytes. The maximum value for n is 32767. | Padded with blanks to length of buffer. |
DT_NSTRING | Length of buffer. | null character at end of string. |
DT_NVARCHAR(n) | Maximum length of NVARCHAR structure (n+2). The maximum value for n is 32765. | len field of NVARCHAR structure set to actual length in bytes of string. |
DT_SMALLINT | No action required. | No action required. |
DT_STRING | Length of buffer. | null character at end of string. |
DT_TIME | Length of buffer. | null character at end of string. |
DT_TIMESTAMP | Length of buffer. | null character at end of string. |
DT_TIMESTAMP_ STRUCT | No action required. | No action required. |
DT_UNSBIGINT | No action required. | No action required. |
DT_UNSINT | No action required. | No action required. |
DT_UNSSMALLINT | No action required. | No action required. |
DT_VARCHAR(n) | Maximum length of VARCHAR structure (n+2). The maximum value for n is 32765. | len field of VARCHAR structure set to actual length in bytes of string. |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |