I had in the past had to work with oracle and had to convert it to mysql. Unfortunately (or fortunately) that project was cancel but here are the bit of information I’ve found that I didn’t know about and made me lost a lot of time.
Oracle vs mySQL datatype edition
From mySQL Forum:
NUMBER Any NUMERIC
DEC Any NUMERIC
DECIMAL Any NUMERIC
NUMERIC Any NUMERIC
DOUBLE PRECISION Any NUMERIC
FLOAT Any NUMERIC
REAL Any NUMERIC
SMALLINT Any SMALLINT
VARCHAR <256 VARCHAR
VARCHAR2 <256 VARCHAR
CHAR <256 CHAR
VARCHAR2 >255 TEXT
VARCHAR >255 TEXT
CHAR >255 TEXT
LONG <256 VARCHAR
LONGRAW <256 VARCHAR
RAW <256 VARCHAR
LONG >255 TEXT
LONGRAW >255 TEXT
RAW >255 TEXT
DATE – DATETIME (Since DATE in oracle can include time information!)
From what we needed we had to
decimal(50,0) = NUMBER
decimal(22,0) = INTEGER
DATE = datetime
Now that I look at it I think It would have been better to turn them both to number.
The best course of action is to find a DBA and use tool for the job like omega sync like it’s recommended in the following stackoverflow thread.
Recent Comments