Neoview SQL Reference Manual (R2.4)

UNSIGNED is supported as extended NUMERIC precision data type—
— SIGNED is supported as 64-bit integer
• CAST function allows conversion between regular NUMERIC and extended NUMERIC
precision data type.
• Parameters in SQL queries support extended NUMERIC precision data type.
Example for Extended NUMERIC Precision Data Type
>>CREATE TABLE t( n NUMERIC(128,30)) NO PARTITION;
--- SQL operation complete.
>>SHOWDDL TABLE t;
CREATE TABLE SCH.T
(
N NUMERIC(128, 30) DEFAULT NULL
)
NO PARTITION
;
--- SQL operation complete.
>>
Character String Data Types
Neoview SQL includes both fixed-length character data and variable-length character data. You
cannot compare character data to numeric, datetime, or interval data.
character-type is:
CHAR[ACTER] [(length [CHARACTERS])] [char-set]
| CHAR[ACTER] VARYING(length) [CHARACTERS][char-set]
| VARCHAR(length) [CHARACTERS] [char-set]
| NCHAR [(length)] [CHARACTERS]
| NCHAR VARYING (length) [CHARACTERS]
| NATIONAL CHAR[ACTER] [(length)] [CHARACTERS]
| NATIONAL CHAR[ACTER] VARYING (length) [CHARACTERS]
char-set is
CHARACTER SET char-set-name
CHAR, 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. Although you can specify only
ISO88591 or UCS2 for the character column definition, the character set configuration of your
Neoview platform permits you to store character string data encoded in other character sets.
For more information, see the Neoview Character Sets Administrator's Guide.
CHAR[ACTER] [(length [CHARACTERS])] [char-set] [UPSHIFT]
specifies a column with fixed-length character data.
Data Types 233