'Get binary string from BINARY(180) in mysql
I have a column X of type BINARY(170) for 1360 bitmap and want a column Y with bitmap string like '001101....'
tried using LPAD((CONV(HEX(X),16,2)),1360,'0') AS Y
but since CONV works only till 64 bit number, this gives wrong answer.
How could I accomplish this in MySQL ?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|