converting binary column to text using column to import

[s_porkalai]

hi all,

I am using column to import stage to convert binary to text. The problem is, there is some null values are in the middle of binary column. so when column import converts binary into text, it is truncating upto the last character before the null leaving remaining as blank space. so i am not getting the characters after the null in output.

is there any way to resolve this. or is there any way to convert binary data into varchar

regards
Lakshmi

[ray.wurlod]

Try changing the APT_STRING_PADCHAR value so that it's not NUL.