Converting from Binary(40) to Varchar 255

oracle · Post by **oracle** » Thu Feb 07, 2013 2:30 am

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

FranklinE · Post by **FranklinE** » Thu Feb 07, 2013 12:39 pm

Check the 8x documentation (I plan to at some point). In 7x there is no raw (binary) to VarChar funtion to be found.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 07, 2013 3:55 pm

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.)

FranklinE · Post by **FranklinE** » Thu Feb 07, 2013 4:16 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 07, 2013 6:22 pm

Can you apply RAWTOHEX() function when extracting?