Adaptive Server provides several system datatypes and the user-defined datatypes timestamp, sysname, and longsysname. Table 1-1 lists the categories of Adaptive Server datatypes. Each category is described in a section of this chapter.
Category |
Used for |
---|---|
Numeric values (both integers and numbers with a decimal portion) that must be represented exactly |
|
Numeric data that can tolerate rounding during arithmetic operations |
|
Monetary data |
|
Tables that are browsed in Client-Library™ applications |
|
Date and time information |
|
Strings consisting of letters, numbers, and symbols |
|
Raw binary data, such as pictures, in a hexadecimal-like notation |
|
True/false and yes/no type data |
|
System tables |
|
Printable characters or hexadecimal-like data that requires more than the maximum column size provided by your server’s logical page size. |
|
Abstract datatypes |
Adaptive Server supports abstract datatypes through Java classes. See Java in Adaptive Server Enterprise for more information. |
Defining objects that inherit the rules, default, null type, IDENTITY property, and base datatype of the datatypes listed in this table. text undergoes character-set conversion if client is using a different character set, image does not. |