Re: Problem in decimal separator

At 12:44 +0100 11/4/02, [EMAIL PROTECTED] wrote: I have a problem when I load a text file using the sentence "load data infile" as long as decimals are separated by commas and mysql ignores those decimals, is there any way to specify that decimal separator is comma or point? No.

re: Problem in decimal separator

way to specify that decimal separator is comma or Jaedddc> point? No, you can't. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/

Problem in decimal separator

I have a problem when I load a text file using the sentence "load data infile" as long as decimals are separated by commas and mysql ignores those decimals, is there any way to specify that decimal separator is comm

Re: Decimal separator

So sprach »Lars G 'LG' Örne« am 2001-12-07 um 13:19:00 +0100 : > MySQL, float fields: Can I change from "." to ","? Nope, they are always stored with . in the DB. However, when SELECTing, you can easily convert using MySQLs replace() function. Alexander Skwar -- >> Wohnung in Gel

Decimal separator

MySQL, float fields: Can I change from "." to ","? /Lars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[

Sum function not uses a valid decimal separator.

Sorry about that because there probably will be a stupid question but I'm from Spain, and i use the "," to represent decimal separator : 123.456,01 ? well, the function sum in mysql 3.23.42 belive that "." is the decimal separator and then when he finds a ",