Open Source RDBMS - Seamless, Scalable, Stable and Free

English | 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
문서 정보
viewed 6896 times
번역 en
작성자
posted 2년 전
CUBRID
공헌자
마지막 수정시간 2년 전
변경 내역 보기
tagged
Share this article