Hi Paul,
2003年 7月 9日 水曜日 11:17、Paul DuBois さんは書きました: > At 12:31 +0900 7/8/03, Nils Valentin wrote: > >Hi Koh, > > > >Shouldn't the value in the first sample be used like this ? > > > >1) SELECT * FROM table1 WHERE field1 = '0x61006200630064000000'; > > > >Correct me if I am wrong. > > You're wrong. :-) > > 0x61006200630064000000 is a hex literal, which will be treated as > a string constant or an integer constant depending on context. > > '0x61006200630064000000' is a string constant consisting of the > characters '0', 'x', '6', ... Thanks for pointig this out, the second lesson for me today to learn ;-) Best regards Nils Valentin Tokyo/Japan > > >Best regards > > > >Nils Valentin > >Tokyo/Japan > > > >2003îN 7åé 8ì™ â‘ójì™ 11:55ÅAKoh Swee Meng > >Ç„ÇÒÇÕèëÇ´ÇÐǵLJ: > >> 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 > > -- > Paul DuBois, Senior Technical Writer > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > Are you MySQL certified? http://www.mysql.com/certification/ -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
