unhex a varchar column

2004-02-10 Thread Mark S Pryor
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 sele

unhex a varchar column

2004-02-09 Thread Mark S Pryor
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 sele