Retrieving values

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. \0 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. See Retrieving LONG data. Length field ignored. See Retrieving LONG data.
DT_LONGNVARCHAR Length field ignored. See Retrieving LONG data. Length field ignored. See Retrieving LONG data.
DT_LONGVARCHAR Length field ignored. See Retrieving LONG data. Length field ignored. See Retrieving LONG data.
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. \0 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. \0 at end of string.
DT_TIME Length of buffer. \0 at end of string.
DT_TIMESTAMP Length of buffer. \0 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.
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1