Multi-database support

Offically supported databases

Vendor	Versions
mysql	4.0, 4.1, 5.0
hsqldb	1.8.0

XPlanner usage	MySql	HSQLDB	Oracle
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)

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`

Operation	MySql	HSQLDB	Oracle	Postgres
Rename column	`ALTER TABLE <table> CHANGE <columnname> <newname> <columntype>;`	`ALTER TABLE <tablename> ALTER COLUMN <columnname> RENAME TO <newname>`