|
| |
This version of Advanced DB Master is ODBC compatible.
That means you can share information between databases created with Advanced DB Master and databases created with other ODBC compatible products like Microsoft
Access. You can even attach tables from other products to your ADBM database. And Advanced DB
Master's storage limitations are much more
generous than most other popular database products, for example each record in a table can
be up to 32 kilobytes in size. Take a look at the other specifications below:
Advanced DB Master 7 Database and Table Limits
250 tables in a Database
4,000 fields in a Table
10 fields in a Primary Key
10 fields in a Secondary Key
122 characters in Primary Key or Secondary Key
250 Secondary Key indexes
32,200 characters in a record
16,000 characters in a Fixed Character or Fixed Binary field
256,000 Gbyte of data in each Table
2,147,483,648 records per Table
Data Types Supported by Advanced DB Master
7
SQL Driver
| Type |
Storage |
Ranges |
| Fixed Character |
length+1 |
1 to 16000
ASCII characters |
| Boolean |
1 |
0 or 1 |
| Unsigned Byte |
1 |
0 to 255 |
| Signed Byte |
1 |
-128 to 127 |
| Unsigned Short |
2 |
0 to 65,535 |
| Signed Short |
2 |
-32,768 to
32,767 |
| Unsigned Long |
4 |
0 to
4,294,967,295 |
| Signed Long |
4 |
-2,147,483,648
to 2,147,483,647 |
| Short Real |
4 |
3.4E +/- 38 (7
digits) |
| Long Real |
8 |
1.7E +/- 308
(15 digits) |
| Currency/BCD |
length+1 |
1 to 30 decimal
digits |
| Date |
6 |
Year 0 to 9999 |
| Time |
6 |
Hour 0-23,
minute 0-59, second 0-59 |
| Datetime |
16 |
Year 0 to 9999,
hr,min,sec, fraction 0-8 digits |
| Fixed Binary |
length+2 |
1 to 16000 |
© Macon Systems, Inc. - all rights
reserved. Last update was
26 July, 2006
|
