LucidDbDataTypes

From Eigenpedia

Jump to: navigation, search

Syntax

data-type ::=
{ character-type | binary-type } [ ( length ) ] [ CHARACTER SET charset-name ]
| decimal-type [ ( precision [ , scale ] ) ]
| integer-type
| approximate-type
| BOOLEAN
| DATE
| TIME
| TIMESTAMP
character-type ::=
{ CHARACTER | CHAR } [ VARYING ]
| VARCHAR
binary-type ::=
BINARY [ VARYING ]
| VARBINARY
integer-type ::=
TINYINT
| SMALLINT
| INT | INTEGER
| BIGINT
decimal-type ::=
DECIMAL | DEC | NUMERIC
approximate-type ::=
REAL
| FLOAT
| DOUBLE [ PRECISION ]

Notes

  • If unspecified, character length defaults to 1
  • Maximum character length is 65535 (actual maximum for stored rows is smaller due to default 32K page size)
  • If unspecified, numeric precision defaults to 19; scale defaults to 0
  • Maximum numeric precision/scale is 19
  • The only character set name currently supported is "ISO-8859-1"
  • TIME and TIMESTAMP do not support fractional seconds
  • REAL corresponds to a 32-bit IEEE float
  • DOUBLE corresponds to a 64-bit IEEE double
  • FLOAT is equivalent to DOUBLE PRECISION
  • When precision is lost by a numeric operations, LucidDB always performs rounding rather than truncation
Personal tools