1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Rep Power
    Does anybody know if there's anything special to consider when importing floating point values? I have imported a text file containing such values (like '518,99', german style with comma) and mysql seems to round them. Do i just have to convert it to '518.99' (american style)? However, the comma is recognized correctly as the floating point... but, the values get rounded.
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Niagara Falls (On the wrong side of the gorge)
    Rep Power
    Actually, no, it isn't interpreting the comma correctly and it isn't rounding. MySQL does not recognize the comma as a valid character for numerical data input so it ignores it and everything after it.

    I'm not sure if there is a setting to change the decimal character from a . to a , or not but it seems to me this would be likely. Check the MySQL docs.

Similar Threads

  1. comparing values from tbl1 to tbl2 Access2000??
    By mauron in forum Database Management
    Replies: 0
    Last Post: December 12th, 2003, 02:23 PM
  2. Displaying prev() and next() values from an array
    By mike972 in forum PHP Development
    Replies: 5
    Last Post: January 31st, 2003, 03:55 PM
  3. Accesing dates in Mysql thru PHP
    By carlmty in forum PHP Development
    Replies: 1
    Last Post: January 7th, 2003, 03:52 AM
  4. Setting precision of floating point numbers
    By gbickford in forum PHP Development
    Replies: 1
    Last Post: September 21st, 2001, 01:44 PM
  5. Replies: 6
    Last Post: November 9th, 2000, 02:49 AM

IMN logo majestic logo threadwatch logo seochat tools logo