Re: "select * from table where field=hex" doesnt work

[Nils Valentin]

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
> DŽÇÒÇÕèëÇ´ÇÐǵ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: nils@stripped
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils