DSXchange

Posted: **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]

Posted: **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.

Posted: **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."

Posted: **Thu Mar 31, 2016 4:39 pm**

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

Posted: **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.

Posted: **Thu Mar 31, 2016 9:23 pm**

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

DSXchange

Teradata warning: Implicit conversion from source type

Teradata warning: Implicit conversion from source type