|
|
 |
|
Database Comparisons
As you may know we support many different types of databases at ChamberGates. Our goal is to
provide our customers with the greatest amount of flexibility we can. However, all of this
flexibility can be confusing for users that have not already standardized on a database format.
For that reason we have created this side-by-side comparison to help you decide which database
is right for you.
|
|
|
| Building the List |
|
| Features |
Microsoft
Access |
MySQL |
Microsoft
SQL Server |
| Storage Type |
File |
Server |
Server |
| Plan Requirement |
Bronze |
Silver |
Silver |
| Additional Cost |
None |
None |
$20/month |
| Data Types |
| Char |
Not Supported |
1 to 255 |
1 to 8,000 |
| Varchar |
1 to 255 |
1 to 255 |
1 to 8,000 |
| Text |
1 to 65,535 |
1 to 4,294,967,295 |
1 to 2,147,483,647 |
| DateTime |
100-9999
(seconds) |
1000-9999
(seconds) |
1753-9999
(milliseconds) |
| Integer |
-2,147,483,648 to 2,147,483,647 |
-9.22E+18 to 9.22E+18 |
-2.14E+9 to
2.14E+9 |
| Decimal |
-1.79E+308 to
1.79E308 |
-1.79E+308 to 1.79E308 |
-1.79E+308 to 1.79E308 |
| Timestamp |
Not Supported |
Yes |
Yes |
| Data Integrity |
| Foreign Keys |
Yes |
No |
Yes |
| Default Values |
Dynamic |
Static |
Dynamic |
| Check Constraints |
Yes |
No |
Yes |
| Triggers |
No |
No |
Yes |
| Data Checking |
Yes |
No |
Yes |
| Programming |
| ANSI SQL |
No |
Yes |
Yes |
|
|
