Data Integration Studio - Failed to transcode data from U_UTF8_CE to U_LATIN5_CE

[dincooo]

Hi everyone,

I have a table containing Turkish character in it and it is stored in SAS library. 

This table's encoding option is latin5 which supports Turkish characters.

When I'm trying to transfer this table to Oracle library it is saying Failed to transcode data from U_UTF8_CE to U_LATIN5_CE. (Also attached the entire error)

I try to change Oracle library option ==> encoding=latin5 but it didn't work.

Do you have any idea about this situation.

Many thanks,

Onur

[Patrick]

On a generic level: You get this error if SAS isn't able to map a multibyte character set source (UTF-8) into a single byte target (U_LATIN5_CE).

You tell us though that your source table is encoded in latin5 - so you shouldn't have this issue.

If you look at your flow then you're not directly mapping your physical source table to target but an intermediary SAS work table. I'm guessing that you run your SAS session under UTF-8 and that your work tables are encoded in UTF-8. If that's so then one thing you could try is to either set your whole session encoding to latin5 OR to add the encoding option for latin5 to all your work tables.