Frederic Wenzel napsal(a):
Hey,
I have a table with a SMALLINT column that -- trough a mistake --
contains values like 57, 13 etc. which in fact are 0x57 and 0x13 (i.e.
HEX numbers).
How would I convert
13 ("false decimal") to 0x13 (Hex) and from there to 19 (decimal)?
I tried my luck with UNHEX and CAST but I only got 0 or NULL back
respectively.
Thanks in advance
Fred
conv('column_name', 16, 10)
Dusan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]