Character-based Querying and Reporting Tools User Guide > Character-based Querying and Reporting Tools User Guide > Working with Data Types and Data Display Formats > Data Display and Input Formats > Default Data Display Formats
Was this helpful?
Default Data Display Formats
The following table lists default display formats for each SQL data type. For more information, see the appendix “Data Types” for OpenSQL and QUEL data type equivalents.
SQL Data Type
For Forms and Most Reports
For Block Style Reports
c1 ‑ c35
c1 ‑ c35
c1 ‑ c35
c36 ‑ cx
cj0.35
cj0.35
char(1) ‑ char(35)
c1 ‑ c35
c1 ‑ c35
char(36) ‑ char(x)
cj0.35
cj0.35
text(1) ‑ text(35)
c1 ‑ c35
c1 ‑ c35
text(36) ‑ text(x)
cj0.35
cj0.35
varchar(1) ‑ varchar(35)
c1 ‑ c35
c1 ‑ c35
varchar(36) ‑ varchar(x)
cj0.35
cj0.35
integer1
f6
f10
smallint (integer2)
f6
f10
integer (integer4)
f13
f10
decimal (31.31 ‑ 31.0)
Based on size. For example, decimal (5.1) defaults to f7.1, allowing additional digits for the decimal point and an optional plus (+) or minus (‑) sign.
float4
n10.3
f10.3
float (float8)
n10.3
f10.3
date
c25
c25
money
$‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑.nn
$‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑.nn
Note:  'x' represents the lesser of the maximum configured row size and 32,000.
Note:  All character data types are fully supported in non‑Ingres databases accessed through Enterprise Access products, in which case the column size limit can be greater than 2000 bytes. Other data types may not be supported by all Enterprise Access products.
If your computer supports the IEEE standard for floating point numbers, the range and accuracy of floating point numbers reflect that standard.
Last modified date: 08/14/2024