Imagine a field with just two numerals, 250 and 2.8.
How would I designate that field if I want to display
them?
First, I tried decimal 3,1. It displayed numerals like
250 perfectly, but it rounded all the decimals off,
turning 2.8 into 3.
So I converted the field to char 3 and made sure the
cells in my spreadsheet were TEXT before saving it as
a csv file and importing it. But the results are the
same.
.5 displays as 1, 2.8 as 3, etc. What am I doing
wrong? However, I went into phpMyAdmin, and the
numerals look correct - .5, 2.8, etc. So why are they
being rounded when displayed?
Thanks.
__________________________________
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
