Migration of Special Characters of UNICODE to TERADATA

Database
Enthusiast

Migration of Special Characters of UNICODE to TERADATA

Hi all,

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.

Regards

Jagdish

4 REPLIES
Teradata Employee

Re: Migration of Special Characters of UNICODE to TERADATA

How are you loading the data? What "client character set" is being used for that load?

Enthusiast

Re: Migration of Special Characters of UNICODE to TERADATA

Hi Fred,

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

Regards,

Teradata Employee

Re: Migration of Special Characters of UNICODE to TERADATA

Do you export from SQL Server as UTF16?

Did you specify "-c UTF16" option in the MLOAD invocation?

Enthusiast

Re: Migration of Special Characters of UNICODE to TERADATA

Thanks for your time.

Will try out this option and will let you know the results soon