QUEL Reference Guide > QUEL Reference Guide > QUEL Data Types > Data Types > Storage Formats of Data Types
Was this helpful?
Storage Formats of Data Types
The following table lists storage formats for QUEL data types:
Notation
Type
Range
char(1) - char(n)
character
A string of 1 to n characters; n represents the lesser of the maximum configured row size and 32,000.
c1 - cn
character
A string of 1 to n characters; n represents the lesser of the maximum configured row size and 32,000.
varchar(1) - varchar(n)
character
A string of 1 to n characters; n represents the lesser of the maximum configured row size and 32,000.
text(1) - text(n)
character
A string of 1 to n characters; n represents the lesser of the maximum configured row size and 32,000.
BOOLEAN
1-byte binary
BOOLEAN type is stored as a single-byte integer that takes only values 0 and 1.
i1
1-byte integer
-128 to +127
i2
2-byte integer
-32,768 to +32,767
i4
4-byte integer
-2,147,483,648 to +2,147,483,647
IPv4
4-byte binary
IPv4 is a 4-byte host address in dotted-decimal notation (four decimal numbers, each ranging from 0 to 255, separated by dots).
For example:172.16.254.1.
IPv6
16-byte binary
IPv6 is a 16-byte host address in eight groups of four hexadecimal digits separated by colons.
For example: 2001:0db8:85a3:0042:1000:8a2e:0370:7334.
float4
4-byte floating
-1.0e+38 to +1.0e+38
(7 digit precision)
float
8-byte floating
-1.0e+38 to +1.0e+38
(16 digit precision)
date
date (12 bytes)
1-jan-0001 to 30-dec-9999 (for absolute dates) and
-9999 years to 9999 years (for time intervals)
money
money (8 bytes)
$-999,999,999,999.99 to $999,999,999,999.99
byte
binary
Fixed length binary data, 1 to maximum configured row size.
byte varying
binary
Variable length binary data, 1 to maximum configured row size.
UUID
binary
Universal Unique Identifier (UUID) is a 128 bit, unique identifier. They can be generated on demand (10 million per second per machine if needed).
Note:  If your hardware supports the IEEE standard for floating point numbers, the float type is accurate to 14 decimal precision ($-dddddddddddd.dd to $+dddddddddddd.dd) and ranges from -10**308 to +10**308, and the money type is accurate to 14 decimal precision.
Last modified date: 08/29/2024