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 Hi, I agree with Andreas : I have make a mistake, I have used DATE and I forgot the "respectively" between MySQL datatypes and Oracle datatypes. So to be clear, I've converted: TEXT to CHAR, VARCHAR, CLOB depending on my needs DATETIME to DATE bye.