Thanks for the reply Kim! On Tuesday 18 November 2003 12:47 pm, you wrote: > Hello Robert ,, > > I have no explanation , just a dummy question , > 1) Are all values u try to put into column 5 a float with . ?
Always floats. > 2) what if u try with integer ?? without . ? haven't yet tried. > 3) can u input float values in column 3 ? >From MySQLCC - yes. > 4) are u running mysqlcc from same pc ? Yes - against a local copy of mysqld > 5 could it be some settings with decimal point is set to something > diff than . depending of ur enviroment ? Not that I can tell. I have 3 seperate MySQL servers (Production, Test and Development) The problem appears to be happening on this one table on all 3 machines. And to make matters worse, the value in field 3 is a float too. The *only* thing I can think of is that the value of field 6 being simply 2 quotes is causing some confusion for field 5. But that I can import from MySQLCC, I would say that I've messed up the data somehow. Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]