MySQL Forums
Forum List  »  Other Migration

problem with data type conversion during migration
Posted by: ujvala ujvala
Date: November 09, 2005 12:54AM

hi all!

when i try to migrate the tables containing 'money' data type from sql to mysql, i used the decimal(19,4) in the stored procedures during migration; but as it does not reflect the same result as in sql, i used the char(30) as the replacement datatype for 'money'.

and here, my question is after migration, when i check the mysql, for that table, i found out that the char data type what i've used has been converted to 'double charset' in mysql automatically.

why it is happening so. i am new to mysql. if this is a stupid question plz excuse me!!

can anyone tell me why is it happening so!!

thanx in advance

UJVALA

Options: ReplyQuote


Subject
Views
Written By
Posted
problem with data type conversion during migration
3861
November 09, 2005 12:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.