OpenSQL Reference Guide > OpenSQL Reference Guide > OpenSQL Data Types > Storage Formats of Data Types
Was this helpful?
Storage Formats of Data Types
The following table lists storage formats for OpenSQL data types:
Notation
Type
Range
character(1) ‑ character(n)
character
n represents the lesser of the maximum configured row size and 32,000.
varchar(1) ‑ varchar(n)
character
n represents the lesser of the maximum configured row size and 32,000.
long varchar
character
A string of 1 to 2 GB characters
nchar
Unicode
A string of 1 to maximum configured row size, but not exceeding 16,000 characters (32,000 bytes).
nvarchar
Unicode
A string of 1 to maximum configured row size, but not exceeding 16,000 characters (32,000 bytes).
long nvarchar
Unicode
A string of 1 to a maximum of 1 GB Unicode characters (that is, 2 bytes to a maximum of 2 GB in length).
tinyint
1-byte integer
-128 to +127
smallint
2‑byte integer
‑32,768 to +32,767
integer
4‑byte integer
‑2,147,483,648 to +2,147,483,647
bigint
8-byte integer
-9,223,372,036,854,775,808 to +9,223,372,036,854,775,807
decimal(p, s)
fixed‑point exact numeric
Depends on precision and scale; default is (5,0): ‑99999 to +99999. Maximum number of digits is 39.
real
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
money
money (8 bytes)
$-999,999,999,999.99 to $999,999,999,999.99
long byte
binary
1 to 2 GB of binary data
Note:  If your hardware supports the IEEE standard for floating-point numbers, then the float type is accurate to 14 decimal precision ($‑dddddddddddd.dd to $+dddddddddddd.dd) and ranges from ‑10**308 to +10**308.
Last modified date: 04/03/2024