Hi, I want to insert data into a floating-point column that is NaN or +/- Infinity. Since MySQL seems to use IEEE floating point numbers, how can I insert and test for these values?
Also, what is the proper string representation of NaN and Infinity when I load data with LOAD DATA INFILE command? Thanks! Casey __________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]