Control characters while exporting the data

General
Enthusiast

Control characters while exporting the data

Hi all,

I am exporting the data using fastexport. While exporting data, 3 to 4 fields I am casting as varchar. After exporting, these filed also contains the control characters like ^@ ^M ^A ^G etc. Can anyone suggest how to avoid these control characters.

Thank you,

Kamlesh

2 REPLIES
Junior Supporter

Re: Control characters while exporting the data

This question has been answered over and over again.

The 'control characters' that you see are the bytes indicating the length of the varchar fields.

Cheers.

Carlos.

Enthusiast

Re: Control characters while exporting the data