Datatype synonyms are included for ANSI compatibility.
The keyword VARYING complies with ANSI-standards to allow variable-length character or binary strings. The VARYING keyword is valid with the character, char, and binary datatypes. Using the VARYING keyword with any other datatype generates syntax errors.
These are the datatype mappings:
| User-defined datatype | Mapped to system datatype |
|---|---|
| binary varying | varbinary |
| char varying | varchar |
| character | char |
| character | char(1) |
| character(n) | char(n) |
| character varying(n) | varchar(n) |
| dec | decimal |
| double precision | float |
| float[(n)] for n = 1–7 | real |
| float[(n)] for n = 8–15 | float |
| integer | int |