SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Language Elements
HP NonStop SQL/MX Reference Manual—540440-003
6-19
Character String Data Types
You can select the rows from the table:
>>select * from $vol.subvol.tfloat;
C1 C2 C3
----------- ----------- -------------------------
10 ? -1.15792089237316160E+077
--- 1 row(s) selected.
Character String Data Types
Considerations for Character String Data Types
SQL/MP Considerations for Character String Data Types
SQL/MX includes both fixed-length character data and variable-length character data.
You cannot compare character data to numeric, datetime, or interval data.
CHAR, PIC, NCHAR, and NATIONAL CHAR are fixed-length character types. CHAR
VARYING, VARCHAR, NCHAR VARYING and NATIONAL CHAR VARYING are
varying-length character types.
length
is a positive integer that specifies the number of characters allowed in the column.
You must specify a value for length.
char-set-name
is the character set name, which can be ISO88591 or UCS2 for any use or KANJI
or KSC5601 if the data type is not used to define an SQL/MX column.
character-type is:
CHAR[ACTER] [(length [CHARACTERS])] [char-set]
[collate-clause] [UPSHIFT]
| PIC[TURE] X[(length)] [CHARACTERS] [char-set] [DISPLAY]
[collate-clause] [UPSHIFT]
| CHAR[ACTER] VARYING(length) [CHARACTERS][char-set]
[collate-clause] [UPSHIFT]
| VARCHAR(length) [CHARACTERS] [char-set]
[collate-clause] [UPSHIFT]
| NCHAR [(length)] [CHARACTERS] [collate-clause] [UPSHIFT]
| NCHAR VARYING (length) [CHARACTERS] [collate-clause]
[UPSHIFT]
| NATIONAL CHAR[ACTER] [(length)] [CHARACTERS]
[collate-clause] [UPSHIFT]
| NATIONAL CHAR[ACTER] VARYING (length) [CHARACTERS]
[collate-clause] [UPSHIFT]
char-set is
CHARACTER SET char-set-name
collate-clause is
COLLATE collation