Archives of the TeradataForum
Message Posted: Tue, 19 Dec 2006 @ 11:42:21 GMT
<-- Anonymously Posted: Tuesday, December 19, 2006 04:39 -->
It would be of great help if you could help me to know how to frame the SQL for Conversion from Hex to Char.
I do know how to convert a string value from Char to hex and vice - versa
Sel CHAR2HEXINT( TRANSLATE('Test' USING UNICODE_TO_LATIN) ) -- 54657374 Sel '54657374'XC -- Test
But If I insert the string into a table as a hex how do I get the value back from the table ..
Create table Hexcon ( Col1 varchar(30) ) ; Insert into Hexcon Sel CHAR2HEXINT( TRANSLATE('Test' USING UNICODE_TO_LATIN) ) ; Sel col1 from Hexcon -- 54657374 ;
I need to convert this Hex to its original ASCII value 'Test' how to do this ?...
I am able to do the same using a Stored procedure by reading the value from the table one by one and converting it into ASCII value and inserting into another table. But this is very slow.. Is there any other way thru SQL alone.
Thanks for your help
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|