Re: AW: [PHP-DB] Any issues when moving from mySQL to Oracle 8i? From: Andreas Karajannis (Andreas.Karajannis <email protected>)
Date: 11/10/00

> >
> > 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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>