1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    San Juan, Argentina
    Rep Power
    When i insert data into table from a csv format text file, i get a bug because...
    one of the fields in my table is float but when i tell phpmyadmin to insert data from text file all the data is changed in this way... 4 eg.
    there's a value in 1 column of 18,25
    the value shown in phpmyadmin is 18.00
    The field is float !! i dunno why phpmyadmin has rounded the value !!

    Anyone have a possible solution ?

    Thanks A LOT in advance.

    Henry - Argentina
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Perth West Australia
    Rep Power
    surely the problem is the comma?

Similar Threads

  1. phpMyAdmin Question.
    By Agarash in forum MySQL Help
    Replies: 1
    Last Post: February 10th, 2004, 12:14 AM

IMN logo majestic logo threadwatch logo seochat tools logo