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

    Join Date
    Aug 2000
    Location
    San Juan, Argentina
    Posts
    6
    Rep Power
    0
    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
    Location
    Perth West Australia
    Posts
    757
    Rep Power
    15
    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