Re: AW: [PHP-DB] Any issues when moving from mySQL to Oracle 8i?

> > > > Hi Joe, > > for this job you should double check the datatypes : for exemple > > mysqldump dumps integer fields with datatype INT (length_of_int) . This is > > not correct for Oracle. > > Look also at TEXT and DATETIME wich have to be converted to CHAR, > > VARCHAR, CLOB .. (depending on your needs) and TIME I would use Oracle's DATE datatype (which can hold date and time information down to seconds) insrtead of converting this to chars. The "Oracle8i SQL Reference" is your friend - available on technet.oracle.com (free registration required). -Andreas -- Andreas Karajannis GMD National Research Center for Information Technology Schloss Birlinghoven, D-53754 Sankt Augustin Phone +49 2241 142948