Added by Jacques Morel, last edited by Jacques Morel on Jun 02, 2007  (view change)

Labels

 
(None)

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>    

Mysql

[MySql]

Hsqldb

HSQLDB

Built-in functions
Type of tables
sequences/autoincrement field