R:BASE Database File Format Comparison
Product Feature RB1-RB4 RX1-RX4
Database File Size Limit 2 GB 2.3 million TB
Data Pointers 32-bit 64-bit
Row Size Limit 4,096 bytes 32,768 bytes
Number of Tables per Database 16,000 32,000
Number of Columns per Table 800 2,048
Number of Computed Columns per Table 80 400
Number of Indexes per Table 400 1,024
Number of Columns per Database 16,000 32,000
Number of Indexes per Database 16,000 32,000
Database Name Limit 8 characters 128 characters
Table/View Name Limit 18 characters 128 characters
Column Name Limit 18 characters 128 characters
Form/Report/Label Name Limit 18 characters 128 characters
User Password Limit 18 characters 128 characters
Expression Size Limit 240 characters 2000 characters
NOTE Data Type Limit 4,096 characters 10,000 characters
"SELECT" Items Limit 100 1024
Number of Items Accumulated in a SELECT 400 1,024
ASCII Expression Size Limit 1,000 2,000
Number of Tokens Limit in a command 2,010 8,020
Database Comments
Database Stored Static Variables
Enhanced DOS to Windows Conversion
64-bit ODBC Driver
32-bit ODBC Driver
Date/Time for Table and View Structure
Date/Time and Version for Forms/Reports/Labels
BOOLEAN Data Type Support
BIGNUM Data Type Support
BIGINT Data Type Support
SMALLINT Data Type Support
WIDETEXT Data Type Support
WIDENOTE Data Type Support
GUID Data Type Support
BSTR Data Type Support
MIGRATE Command for Database Conversions
Increased SQL Query Storage for Views
Front-End Compatibility (Oracle, DB2, MS SQL)