Hi all,

I created a table with the key defined as binary(15), then inserted a
record like this:

insert into table values (0x010203040506070809000102030405,...)

I can retrieve the row with 

select * from table 

and display it via my test program as '123456789012345' (I convert it from
bytes to a string).

However...I cannot retrieve the record specifically using:

select * from table with key=0x010203040506070809000102030405

How can I retrieve this record via the same data I created it with?

(For some reason, select * from table with key=0 selects the row. Go
figure)

-- 
Mark Jenison



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to