In one of our project, we are facing a challenge to load Special character fields onto Teradata.
The source is SQLServer and its character set is UTF16.
Though we are able to load the data, but there are records where data has been corrupted for certain special characters. ( We have set the character set to UNICODE in table defination in teradata)
I wrote a recursive function to identify the users have special characters in their address or name fields.
And we tried loading them via txt file sent by our source team and still the problem persists.
Is there any specific setting in teradata to consider all characters during loading and representing them same.
Thank you in advance for providing your valuable time.
Thanks for your time.
The default client character set on our TD machine is LATIN.
We have overwritten the value with UNICODE character set during execution of MLOAD loading script.
PLease let me know if i need to furnish further values. we are using version TD -13
Do you export from SQL Server as UTF16?
Did you specify "-c UTF16" option in the MLOAD invocation?