List of Supported Data Types
|
Binary
(Byte Stream)
|
BULK
BINARY LARGE OBJECT
BLOB
|
|
Boolean
|
BOOLEAN
|
|
Character
|
CHARACTER
CHAR
SQL_CHAR
NATIONAL CHARACTER
NATIONAL CHAR
NCHAR
ECHARACTER
ECHAR
NLSCHARACTER
NLSCHAR
CHARACTER VARYING
CHAR VARYING
VARCHAR
SQL_VARCHAR
NATIONAL CHARACTER VARYING
NATIONAL CHAR VARYING
NCHAR VARYING
VARNCHAR
TEXT
NLSTEXT
CHARACTER LARGE OBJECT
CHAR LARGE OBJECT
CLOB
NATIONAL CHARACTER LARGE OBJECT
NATIONAL CHAR LARGE OBJECT
NCHAR LARGE OBJECT
NCLOB
|
|
Date
|
EDATE
EPOCH_TIME
ETIME
MICROTIMESTAMP
DATE
SQL_TYPE_DATE
TIME
TIME WITHOUT TIME ZONE
SQL_TYPE_TIME
TIMESTAMP
TIMESTAMP WITHOUT TIME ZONE
SQL_TYPE_TIMESTAMP
|
|
Decimal
|
DECIMAL
DEC
NUMERIC
SQL_DECIMAL
SQL_NUMERIC
DOLLAR
|
|
Float
|
REAL
SQL_REAL
FLOAT32
DOUBLE PRECISION
SQL_DOUBLE
FLOAT64
EFLOAT
FLOAT
SQL_FLOAT
|
|
Integer
|
TINYINT
SQL_TINYINT
INTEGER8
SMALLINT
SQL_SMALLINT
INTEGER16
INTEGER
INT
SQL_INTEGER
INTEGER32
BIGINT
SQL_BIGINT
INTEGER64
|
|
Sequence
|
SEQUENCE32
SEQUENCE64
|
Binary Data
Empress stores binary information readily. This data type allows you to store data values of any length or format, such as those used to represent voice or graphical data. Empress dynamically allocates space when storing binary data.
Character Data
With Empress, you may store character data in fixed-length fields using one of three ways:
- Store only printable characters and strip leading and trailing blanks from data you enter by using
CHARACTER type 1 - Store only printable characters and preserve leading and trailing blanks from data you enter by using
- Store any ASCII character except
using CHARACTER type
3
Date Data
The DATE data type stores dates. There are nine date data formats:
Table 2-3: Empress DATE Data Type Formats
| Type |
Format |
Year Range |
Example
|
|
|
|
|
| 0 |
yyyymmdd |
0000-9999 |
20020627 |
| 1 |
dd aaaaaaaaa yyyy |
0000-9999 |
27 June 2002 |
| 2 |
aaaaaaaaa dd, yyyy |
0000-9999 |
June 27, 2002 |
| 3 |
mm/dd/yy |
nn00-nn99 * |
06/27/02 |
| 4 |
dd/mm/yy |
nn00-nn99 * |
27/06/02 |
| 5 |
dd aaa yy |
nn00-nn99 * |
27 Jun 02 |
| 6 |
aaa dd, yy |
nn00-nn99 * |
Jun 27, 02 |
| 7 |
mm/dd/yyyy |
0000-9999 |
06/27/2002 |
| 8 |
dd/mm/yyyy |
0000-9999 |
27/06/2002 |
*
nn is defined by the
system variable MSDATELIMIT, the value of which is assigned by the user
to indicate the preferred century for entering dates.
Decimal Data
Decimal numbers are stored as DECIMAL or
Dollar Data
Dollar and currency are stored as DOLLAR When using this function, you may store any amount up to 13 digits and use one of three different formats:
| Dollar Type |
Format |
|
|
| 1 |
$1,234.00 |
| 2 |
$****1,234.00 |
| 3 |
1234.00 |
You can use an Empress variable to control the currency, cents, and the thousands' separator (i.e.,
Floating Point Data
Floating point numbers are stored as:
REAL
FLOAT
LONGFLOAT or DOUBLE PRECISION
With FLOAT, you can specify the number of decimal places. Use LONGFLOAT for very high precision.
Integer Data
Integer numeric values are stored as:
TINYINT
8 bits- SMALLINT 16 bits
INTEGER 32 bitsBIGINT 64 bits
MicroSecond Timestamp Data
The MICROTIMESTAMP data type stores TIME plus microseconds information.
The nine different MICROTIMESTAMP styles are shown below:
| Type |
Output Style |
|
|
| 0 |
20070828145615234599 |
| 1 |
28 August 2007 14:56:15.234599 |
| 2 |
August 28, 2007 14:56:15.234599 |
| 3 |
08/28/07 14:56:15.234599 |
| 4 |
28/08/07 14:56:15.234599 |
| 5 |
28 Aug 07 14:56:15.234599 |
| 6 |
Aug 28, 07 14:56:15.234599 |
| 7 |
08/28/2007 14:56:15.234599 |
| 8 |
28/08/2007 14:56:15.234599 |
National Language Support (NLS) Character Data
The NLSCHARACTER data type is essentially the same as the CHARACTER
with the exception of characters being stored in 8-bit.
National Language Support (NLS) Text Data
The NLSTEXT data type is essentially the same as TEXT with the exception of
characters being stored in 8-bit.
NULL or Missing Data
Missing data values are stored internally in a special form, and you may enter and recall these values by using the NULL keyword.
Text Data
The TEXT data type will store character data varying from several characters to many pages, using only as much storage as is needed for the data. This is an extremely powerful and flexible way of storing a wide variety of text passages, including descriptions, abstracts, comments, and word processor output.
Time Data
Time data is stored as TIME. To store time, you may use one of nine formats:
| Type |
Output Style |
|
|
| 0 |
20030828145615 |
| 1 |
28 August 2003 14:56:15 |
| 2 |
August 28, 2003 14:56:15 |
| 3 |
08/28/03 14:56:15 |
| 4 |
28/08/03 14:56:15 |
| 5 |
28 Aug 03 14:56:15 |
| 6 |
Aug 28, 03 14:56:15 |
| 7 |
08/28/2003 14:56:15 |
| 8 |
28/08/2003 14:56:15 |
