Hi there,
I've got a column which contains hex data in string format. I run the following
query:
select conv([column], 16, 10) from [table] limit 5;
The output, though, seems to mess up if two or more consecutive columns contain
the same data. To test this out I did:
select conv("a", 16, 10) from [table] limit 5;
In theory (unless I'm mistaken) this should produce five rows with "10".
Instead, it produces:
OK
10
794
15002
3441418
913786650
Time taken: 17.235 seconds
Can you offer me any suggestions?
Thanks,
Annie Graebner
Return Path
