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