469,622 Members | 2,183 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,622 developers. It's quick & easy.

convert hex string back to binary

Hello,

Using MySQL 4.017 on Win2k sp3:

using MySQL built-ins: how can I convert a
value stored as a hexadecimal string back to
a binary string while logged into the shell?
set @t1=616263;
select 0x616263;


how can I turn @t1 back into 0x616263? What is
the syntax? I tried
select concat('0x', @t1);
this returns an unevaluated literal!

tia,
msp
Jul 19 '05 #1
0 2523

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by David Lawson | last post: by
reply views Thread by Mark S Pryor | last post: by
1 post views Thread by Swarup | last post: by
3 posts views Thread by bussiere maillist | last post: by
7 posts views Thread by elliotng.ee | last post: by
29 posts views Thread by Harlin Seritt | last post: by
5 posts views Thread by =?Utf-8?B?YmJkb2J1ZGR5?= | last post: by
10 posts views Thread by cmdolcet69 | last post: by
7 posts views Thread by =?Utf-8?B?RWl0YW4=?= | last post: by
6 posts views Thread by Bob Altman | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.