Hi, i am trying to load a csv file with "LOAD DATA INFILE". This File contains columns with decimal values with the german comma instead of the dot as separator (e.g. 3.20 is 3,20). Is there an option to handle this during or immediately before LOAD with MySQL Commands/Tools. Now we only see values where the values on the right of the comma have been cut off.
I will be glad for any advice! Thorsten -- http://www.fastmail.fm - One of many happy users: http://www.fastmail.fm/docs/quotes.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]