Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

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
comments powered by Disqus
Page info
viewed 6886 times
translations en
Author
posted 2 years ago by
CUBRID
Contributors
updated 2 years ago by
View revisions
tagged
Share this article