SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
Occasional Contributor
Posts: 16

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

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

Respected Advisor
Posts: 4,672

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

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.

Ask a Question
Discussion stats
  • 1 reply
  • 175 views
  • 0 likes
  • 2 in conversation