[tag]

HI ALL.

Is there a way of doing a ascii to hex conversion in a select statement ??

I have a table that I need to search for a particular string :

select * from table where col1 like '%searching%';

but col1 is stored in the database as HEX ????

Please help
Thanks
Tonino

[rnealejr]

There is a hex() function and a conv() function you can use.

[tag]

Hi,

thanks for the info - BUT I have mysql ver 3.23.52-r1

it does not seem to work on this version ?? only on 4.04. Is there a way to get it to work on 3.23.52-r1 ?????

Thanks
Tonino

[rnealejr]

From the documentation that I have both of these functions were introduced in version 3.22.4.

[snobscure]

Interesting:

grotum:~$ echo 'select version(); SELECT HEX("abc");' | mysql -N -h$HOST -u$USER -p$PASSWORD foo1
3.23.32
0
grotum:~$

Note that the HEX example is straight from the MySQL manual:

http://www.mysql.com/doc/en/String_f...s.html#IDX1160

and is expected to return an, er, useful value:

mysql> SELECT HEX("abc");
-> 616263