Decimal and LOAD DATA

2002-12-27 Thread Jonas C. Voss
the script, hopefully. All thoughts on this appreciated. Thanks. specs: MySQL 3.23.53a-Max RH 7.3 -- // Jonas C. Voss // http://verture.net/ // - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Decimal and LOAD DATA

2002-12-27 Thread Jonas C. Voss
On fredag, dec 27, 2002, at 16:19 Europe/Copenhagen, Paul DuBois wrote: At 15:18 +0100 12/27/02, Jonas C. Voss wrote: Actually, I tried a plethora of formats including the following: 1139 113900 1.139,00 1,139.00 1139,00 1139.00 But MySQL interprets them all as 1.13. Based on that last