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 "," separator in a field returns results that they aren't true.
How can I change the character that mysql uses to represent decimal separator? Thanks a lot for your time and sorry about my bad english... David Tomas Fargas --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php