var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: doing a ascci to hex cnversion ???
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 ????
There is a hex() function and a conv() function you can use.
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 ?????
From the documentation that I have both of these functions were introduced in version 3.22.4.
grotum:~$ echo 'select version(); SELECT HEX("abc");' | mysql -N -h$HOST -u$USER -p$PASSWORD foo1
Note that the HEX example is straight from the MySQL manual:
and is expected to return an, er, useful value:
mysql> SELECT HEX("abc");