Offically supported databases
| Vendor |
Versions |
| mysql |
4.0, 4.1, 5.0 |
| hsqldb |
1.8.0 |
Comparaison
Data types
| XPlanner usage |
MySql |
HSQLDB |
Oracle |
Postgres |
| Ids |
int(11) |
integer |
|
|
| Descriptions |
TEXT |
VARARG(4000) |
VARARG(4000) |
|
| Attachement |
LONGBLOB |
LONGVARBINARY |
|
|
| Enums (should not be really used) |
tinyint(1) |
SHORTINT |
|
|
| Boolean |
tinyint(1) |
BIT (Cannot be null) |
|
|
Case sensitiveness of unique keys and indexes
| Database |
Default behavior |
How to change it |
| MySql |
Case insensitive by default |
? |
| HSQLDB |
Case sensitive by default |
Before creating a table, run SET IGNORECASE true or change type of VARCHAR to VARCHAR_IGNORECASE |
Alteration
| Operation |
MySql |
HSQLDB |
Oracle |
Postgres |
| Rename column |
ALTER TABLE <table> CHANGE <columnname> <newname> <columntype>; |
ALTER TABLE <tablename> ALTER COLUMN <columnname> RENAME TO <newname> |
|
|
