Developers zone > CUBRID Tutorials > CUBRID RDBMS Size Limits

CUBRID RDBMS Size Limits

When working with databases, it is important to understand what the upper and lower bounds are for its data types, database and table size, rows, etc. More than that, it's always good to know if you intend to compare it with other database systems. In this page you can see a table with all the MAX and MIN limitations set in the CUBRID RDBMS.

Constituent	Max	Min	Remarks
Database	unlimited
Table	unlimited
Row	unlimited
Columns per Row	6400
Database Name Length	16
Column Name Length	254
Indexes per table	unlimited
BLOB/CLOB	unlimited
NUMBER	64 bits
DATE	12/31/9999	01/01/0001	00/00/0000 is also allowed for MySQL compatibility.
TIME	23:59:59	00:00:00	0:0:0 is not allowed.
TIMESTAMP	2038-01-19 03:14:07 (GMT)	1970-01-01 00:00:01 (GMT)	'0000-00-00 00:00:00' is allowed for MySQL compatibility.
DATETIME	9999-12-31 23:59:59.999 (GMT)	0001-01-01 00:00:00.000 (GMT)	'0000-00-00 00:00:00' is allowed for MySQL compatibility.
SHORT SMALLINT	+32,767	-32,768	exact numeric
INT INTEGER	+2,147,483,647	-2,147,483,648	exact numeric
BIGINT	+9,223,372,036,854,775,807	-9,223,372,036,854,775,808	exact numeric
NUMERIC DECIMAL	precision p : 38 scale s : 38	precision p : 1 scale s : 0	exact numeric
FLOAT REAL	+3.402823466E+38 (ANSI/IEEE 754-1985 standard)	-3.402823466E+38 (ANSI/IEEE 754-1985 standard)	approximate numeric floating point : 7
DOUBLE DOUBLE PRECISION	+1.7976931348623157E+308 (ANSI/IEEE 754-1985 standard)	-1.7976931348623157E+308 (ANSI/IEEE 754-1985 standard)	approximate numeric floating point : 15
MONETARY	+3.402823466E+38	-3.402823466E+38	approximate numeric

I want to

« CUBRID Configurations Shared Query Plan Caching in CUBRID »

comments powered by Disqus

Page info

viewed 4855 times