variable limits

[whwar9739]

Does anyone know if the different types of variable have any physical limitations? I know that the format of a variable only changes the display of the variable but does not actually limit the size.

Thanks in advance for any help.

 

[tamhas]

Limits on data types are in the Database Administration manual. In brief

BLOB 1GB
CHARACTER Roughly 32KB
CLOB 1GB
DATE 1/1/32768 B.C. to 12/31/32767 A.D.
DATE-TIME Same limit as DATE. TIME limit is: 00:00:00 to 23:59:59
DATE-TIME-TZ Same limit as DATE-TIME. Time zone (TZ) limit is:
–14:00 to +14:00
DECIMAL 50 digits total; 1 to 10 decimal places
INTEGER –2,147,483,648 to 2,147,483,647
INT64 –9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
LOGICAL TRUE/FALSE, YES/NO