Database File Comparison

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
ON DISCONNECT/EXIT Command
MIGRATE Command for Database Conversions
Increased SQL Query Storage for Views
Front-End Compatibility (Oracle, DB2, MS SQL)

Back to Support

R:BASE Technologies, Inc. markets and supports the relational database management system; R:BASE, for application development and business use, along with a variety other database-related software products. The company adheres to three basic principles in the design of its data management products: high-performance, data integrity, and ease of use. This fundamental approach has kept R:BASE at the forefront of the industry as one of the most powerful relation DMS available, with millions of copies sold since its introduction.

SITE LINKS
SITE LINKS
SERVICES
SERVICES
QUICK LINKS
QUICK LINKS
Copyright © 1982-2024, R:BASE Technologies, Inc. All Rights Reserved.
Privacy Policy