New datatypes supported

The following sections describe the new datatypes that are supported by Open Client 15.0 and Open Server for 15.0.

For more information on the new datatypes, see these documents:

• Open Client 15.0 Embedded SQL/C Programmer’s Guide

• Open Client 15.0 Embedded SQL/COBOL Programmer’s Guide

• Open Client 15.0 Client-Library/C Programmer’s Guide

• Open Client 15.0 Client-Library/C Reference Manual

• Open Server 15.0 Server-Library/C Reference Manual

A new C-programming, integer datatype named CS_BIGINT is included. CS_BIGINT is a signed, 8-byte integer datatype for use on 32-bit UNIX platforms.

The following new C-programming, unsigned integer datatypes are included:

• CS_USMALLINT (2-byte unsigned integer)

• CS_UINT (4-byte unsigned integer)

• CS_UBIGINT (8-byte unsigned integer)

Sybase provides related conversion routines to access these unsigned int datatypes from the data server.

A new C-programming server-defined datatype named CS_UNITEXT is included.

CS_UNITEXT is an unsigned, short datatype that contains related conversion routines to access the 2-byte Unicode UTF-16 data from the server. This datatype follows the same rules as CS_TEXT, but in a fixed UTF-16 encoding, regardless of the Adaptive Server default character set.

The variable-length unitext datatype can hold up to 1,073,741,823 Unicode characters (2,147,483,646 bytes).

A new C-programming, server-defined datatype named CS_XML is included.

CS_XML is an internal C-language, unsigned character datatype for all platforms. It includes related conversion routines to access the variable-width XML data from the server.

The behavior of this datatype is similar to the standard CS_TEXT and CS_IMAGE datatypes, except it represents XML data.

Syntactically, CS_XML can be used anywhere that CS_TEXT and CS_IMAGE are used.