SQL/MX Programming Manual for C and COBOL (G06.24+, H06.03+)

Host Variables in C/C++ Programs
HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
3-10
Extended Host Variable Data Types and Generated
C Data Types
Table 3-4. Corresponding SQL, C Host Variable Data Types, and Translated C
Declarations (page 1 of 2)
SQL Data Type C Host Variable Data Type
Translated C
Declaration
CHAR(99)CHARACTER SET
ISO88591
char a[100]
*
char CHARACTER SET IS
ISO88591 a[100]
char CHARACTER SET IS
ISO88591 a[100
CHARACTERS]
char a[100]
CHAR(99)CHARACTER SET
UCS2
char CHARACTER SET IS
UCS2 a[100]
char CHARACTER SET IS
UCS2 a[100 CHARACTERS]
wchar_t a[100]
CHAR(99)CHARACTER SET
KANJI
**
char CHARACTER SET IS
KANJI a[100]
char CHARACTER SET IS
KANJI a[100
CHARACTERS]
wchar_t a[100]
CHAR(99)CHARACTER SET
KSC5601
**
char CHARACTER SET IS
KSC5601 a[100]
char CHARACTER SET IS
KSC5601 a[100
CHARACTERS]
wchar_t a[100]
VARCHAR(99) CHARACTER
SET ISO88591
VARCHAR a[100]
*
VARCHAR CHARACTER SET
IS ISO88591 a[100]
VARCHAR CHARACTER SET
IS ISO88591 a[100
CHARACTERS]
char a[100]
VARCHAR(99) CHARACTER
SET UCS2
VARCHAR CHARACTER SET
IS UCS2 a[100]
VARCHAR CHARACTER SET
IS UCS2 a[100
CHARACTERS]
wchar_t a[100]
* An extra character is generated as a placeholder for a null terminator. The embedded SQL C VARCHAR
data type is SQL:1999.
** KANJI and KSC5601 character sets can be used only with SQL/MP tables.