Teradata warning: Implicit conversion from source type

akonda · Post by **akonda** » Wed Mar 30, 2016 10:43 pm

Hi Guys,

I'm getting the below warning when I'm trying to read the data from Teradata using Teradata Connector stage. Any idea on how to get rid of this warning?

When checking operator: When binding output interface field "SRC_ID" to field "SRC_ID": Implicit conversion from source type "ustring[max=20]" to result type "string[max=20]": Possible truncation of variable length ustring when converting to string using codepage UTF-8.

[Note: Title changed to be more descriptive - Andy]

ray.wurlod · Post by **ray.wurlod** » Wed Mar 30, 2016 11:19 pm

Teradata is using some kind of Unicode encoding (such as UTF-8). Your job is specifying VarChar(20) but is not specifying Unicode in the Extended column of the Columns grid.

akonda · Post by **akonda** » Thu Mar 31, 2016 9:38 am

If I specify Unicode its throwing below warning. Any thoughts ?

"Conversion from UTF-8 character set to UTF-16LE may affect performance."

ray.wurlod · Post by **ray.wurlod** » Thu Mar 31, 2016 4:39 pm

Why do you not specify the same encoding (UTF-8) that Teradata is using?

akonda · Post by **akonda** » Thu Mar 31, 2016 8:31 pm

It is specified to UTF-8 in teradata connector stage and also project default one is UTF-8. Still this warning is occuring.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 31, 2016 9:23 pm

Your job or stage appears to be using UTF-16LE.