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: 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.