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', ...
>
>Best regards
>
>Nils Valentin
>Tokyo/Japan
>
>2003îN 7åé 8ì âójì
> 11:55ÅAKoh Swee Meng
> ÇÇÒÇÕèëÇ´ÇÐǵÇ:
>> 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/
