topic Data Truncated Error During Insert in Talend Studio

Data Truncated Error During Insert

Anonymous — Wed, 10 Oct 2012 00:09:36 GMT

I have a MySQL DB table with a variety of data types, but I am having trouble in particular with currency. I have tried changing the data type at the DB level and in Talend scripting to Float, Int, Decimal and most recently, Double. All data types have produced errors. Double is producing a "Data truncated for column 'Charges' at row 1".
What is the best data type to use for currency (need for sorting) and how can I get talend to insert the data?
Thanks
Jeff

Re: Data Truncated Error During Insert

Anonymous — Wed, 10 Oct 2012 03:17:06 GMT

Hi,
We have designed a demo job, you can take it into consideration. We set the data type of currency as "String" . see the pic to get the details.

Best Regards
Sabrina

Re: Data Truncated Error During Insert

Anonymous — Wed, 10 Oct 2012 20:12:10 GMT

String works for the insert, but if you intend to sort your results by currency at the application side, it will sort as:
0.67
1.24
10.23
107.76
2.54
20.45
200.45
3.76
and on and on. Setting as an integer, float, double, decimal will allow sorting by true numeric value.

Re: Data Truncated Error During Insert

Anonymous — Thu, 11 Oct 2012 03:28:23 GMT

Hi,
Set the data type as Float and give a length to it.

What is the best data type to use for currency (need for sorting)

See pics
Best Regards
Sabrina