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.
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.
You can find a workaround here: http://forums.teradata.com/forum/tools/fastexport-how-to-export-without-beginning-two-bytes