Re: Truncated Data
Posted by: Sebastien Caisse
Date: November 24, 2005 09:35AM

Indeed, here is what I rememeber from what hapenned:

This happens in floating point. When using floating point, if the value exceeds the defined limit (which by default is 7.2), the behavior of a normal transaction in SQL is to fail (and thus the entire table isn't transfered), where as the "MySQL old" behavior was to max out the value.

To this effect I strongly suggest checking your floating point data to see wether it has been converted properly...



Edited 1 time(s). Last edit at 11/24/2005 09:35AM by Sebastien Caisse.

Options: ReplyQuote


Subject
Written By
Posted
November 22, 2005 05:12PM
November 23, 2005 06:53AM
November 23, 2005 12:40PM
Re: Truncated Data
November 24, 2005 09:35AM
November 25, 2005 09:45AM


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.