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 | ||
| 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 |
Trackback '4'
Important Facts to Know about CUBRID
All database systems are different one way or another. But utilizing best practices and recommendations are equally important on all systems. To improve your experience ...
last month
CUBRID Tutorials
Quick StartIt is very easy to get started with CUBRID. Follow these step-by-step tutorials and you will see how fun it is to learn CUBRID. Follow [CUBRID Installat...
last month
Important Facts to Know about CUBRID
All database systems are different one way or another. But utilizing best practices and recommendations are equally important on all systems. To improve your experience ...
3 months ago
CUBRID Tutorials
Quick StartIt is very easy to get started with CUBRID. Follow these step-by-step tutorials and you will see how fun it is to learn CUBRID. Follow [CUBRID Installat...
3 months ago
![[Level:7]](http://www.cubrid.org/modules/point/icons/default/7.gif "Rank: 7/30, reputation score 478 (78% completed for the next level)"){kind=icon}
CUBRID