Hi, I am using Spreadsheet::ParseExcel, DBI & DBD::mysql to capture and insert data into mysql tables. That's working out very well but I am having issues with one datatype. When I capture percentages out of excel 97 the captured value might be 0.76324095 but when I attempt to select that same data it always displays as 1 presumably rounding up. Within mysql my select statements show either a 1 or 0:
mysql> select de,cco,fcost,fmarg from quote; +------------+----------+---------+-------+ | de | cco | fcost | fmarg | +------------+----------+---------+-------+ | 1001812321 | 5885 | 1228 | 1 | | 1000267698 | 656160 | 292754 | 1 | | 1001856764 | 40150 | 20361 | 0 | | 1000107528 | 78830 | 39677 | 0 | | 1001928870 | 48062 | 16295 | 1 | where fmarg is the percentage column. When I try and update the value for fmarg I have the same issue: mysql> update quote set fmarg=0.984305 where de= 1001812321; Query OK, 0 rows affected (0.10 sec) Rows matched: 1 Changed: 0 Warnings: 0 mysql> select de,cco,fcost,fmarg from quote; +------------+----------+---------+-------+ | de | cco | fcost | fmarg | +------------+----------+---------+-------+ | 1001812321 | 5885 | 1228 | 1 | The column datatype is INT(25). | fmarg | int(25) | YES | | NULL | | Should I be using a different datatype for these kind of numerical values? Thanks in advance for your kind counsel. Hagen -- Hagen Finley <[EMAIL PROTECTED]> Boulder, CO -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
