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

[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', ...
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/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]