Company

Products

Services

Partners

Media

 

 

 

Home

Empress RDBMS

Empress Servers


Empress APIs

Empress Utilities

Dev. Environments

Facts and Figures


Supported Data Types
Empress Parameters

Supported Platforms
Selected Customers


Free Trial

To Order Empress


Empress Apps for iPad

 

 

         

    List of Supported Data Types

     

    Type Declaration

    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 type 2
    • Store any ASCII character except by 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 You can specify the number of digits and decimal places you need for your data. You may store up to 38 digits.


    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 bits
    • BIGINT 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

     

     

                       
                             
                         

Company
Information
GSA Contracts
Careers
Privacy Policy 
Contact US

Products
Empress RDBMS
Empress Servers
Empress API
Free Trial
 
Empress iPad Apps
 

Services
Consulting
Mobile Apps Development
Technical Support

Training Courses
Empress Extreme  

Partners
Distributors
Business Alliances
Partner Programs  
GSA Program
Distributors Program

Media 
Empress Markets
News and Events
Press releases
Technical News
Success Stories

        USA: 301-220-1919                 Canada & International:       905-513-8888         
Copyright 2014           Empress Software Inc.           info@empress.com           Join Empress Mailing List