i inserted a new record with this SQL "INSERT INTO table1(field1) VALUES(0x61006200630064000000)" type of table1.field1 is tinyblob.
to retrieve the record, i tried SQL belows, 1) SELECT * FROM table1 WHERE field1 = 0x61006200630064000000; 2) SELECT * FROM table1 WHERE field1 LIKE 0x61006200630064000000; 1st SQL found nothing, but the 2nd SQL found the exact record. Is this a bug? I am using mysql 3.23.41 in Linux. Regards, Koh Swee Meng -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]