SQL/MP Installation and Management Guide

Creating a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
5-22
Defining Columns
•
ISO 8859/1 through ISO 8859/9: 8-bit character sets, of which ASCII (a 7-bit set) is
a subset
•
HP Kanji: the HP representation of the character set defined in the JIS X0208
standard and commonly used in Japan
•
HP KSC5601: a double-byte character set that is the Korean Industrial Standard
character set
SQL/MP also supports the UNKNOWN character set for character columns that do not
have a specified character set.
Defining Numeric Data
The data types for numeric data are:
FLOAT is compatible with other numeric data types. SQL/MP performs implicit data
conversion from other numeric types to handle arithmetic or comparison operations
when required.
A column of an exact numeric type can accept a floating-point number. Also, a column
of the FLOAT data type can accept either a floating-point number or an exact numeric
type. These rules apply both to columns of an SQL object and to a host variable field.
When SQL/MP performs arithmetic operations on operands that have mixed data
types, the data type allowing the largest value is used to evaluate the numbers. For
instance, if a REAL number is used and REAL is the data type that allows the largest
value, all other numeric data types are converted first to REAL and then used in the
expression. These numeric data types are in order of increasing size: DECIMAL,
SMALLINT, INTEGER, LARGEINT, REAL, DOUBLE PRECISION.
Note. The NATIONAL CHARACTER (or NCHAR) data type uses the default multibyte
character set for the node. To use the NCHAR data type, the system default multibyte character
set must be a character set that is supported by SQL/MP. For more information, see Hardware
and Software Requirements on page 2-1.
NUMERIC
PIC 9 COMP
Exact numeric binary data
SMALLINT
INTEGER
LARGEINT
Binary integer
FLOAT
REAL
DOUBLE PRECISION
Floating-point number
DECIMAL
PICTURE 9 DISPLAY
Decimal numeric ASCII characters