| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Koh Swee Meng | Date: | July 8 2003 2:55am |
| Subject: | "select * from table where field=hex" doesnt work | ||
| View as plain text | |||
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
