Re: DB & MDB2 Portability

Justin Patrin wrote:

I see that there is support for datetime columns, but not some others, like timestamp, null fields (for Oracle), booleans, CLOB's, Decimals, etc.

Umm...huh? MDB2 has full support for BLOBs (and I assume CLOBS) as well as dates, numbers, etc. Where are you looking for this? It *may* not be implemented for each of the DB backends, but this can always be improved.

http://cvs.php.net/viewcvs.cgi/*checkout*/pear/MDB2/docs/datatypes.html MDB2 does require that you use the appropriate datatypes inside the RDBMS in order to do the mapping reliably. If you really care about portability the best thing to do is to use MDB2_Schema to reverse engineer your current schema into the MDB2 xml schema format. Then you can recreate your database using compatible datatypes. There might be little changes here and there. Like MySQL TIMESTAMP needs to be converted to DATETIME etc. regards, Lukas