Page 1 of 1
Converting from Binary(40) to Varchar 255
Posted: Thu Feb 07, 2013 2:30 am
by oracle
Hi all,
I am reading one columns as Binary(40) and populating into varchar(255).
I did n't find any function converting from Binary to Varchar.
Does any one know how we can convert Binary to Varchar.
Thanks
Posted: Thu Feb 07, 2013 12:39 pm
by FranklinE
Check the 8x documentation (I plan to at some point). In 7x there is no raw (binary) to VarChar funtion to be found.
Posted: Thu Feb 07, 2013 3:55 pm
by ray.wurlod
Is there a string_from_raw() function for the Modify stage in version 7? (I don't have version 7 documentation with me at the moment.)
Posted: Thu Feb 07, 2013 4:16 pm
by FranklinE
ray.wurlod wrote:Is there a string_from_raw() function for the Modify stage in version 7? (I don't have version 7 documentation with me at the moment.)
The 7x guide only lists two available functions in Modify, raw to int8 and to int32.
Posted: Thu Feb 07, 2013 6:22 pm
by ray.wurlod
Can you apply RAWTOHEX() function when extracting?