https://communities.sas.com/t5/SAS-Programming/UTF-8-in-Data-Integration/m-p/634883#M188461 How can I check that from Data Integration IDE?<BR /> Wed, 25 Mar 2020 20:20:05 GMT pabloh2000 2020-03-25T20:20:05Z https://communities.sas.com/t5/SAS-Programming/UTF-8-in-Data-Integration/m-p/634804#M188416 <P>Hi, I'm loading data from MySQL (utf-8), then making some transformations in DI 4.9 and after that I'm trying to insert the result in Postgres (utf-8).</P><P>The problem is with some spanish characters (á, ñ, Ñ, etc.). If I try to insert directly, it shows an error. So I'm using this: putc(char_field,&nbsp;"$UTF8XE250.").</P><P>This function solves the error, but some characters are not properly managed: for example, I can't see the "Ñ" character in Postgres table (it shows some weird stuff).</P><P>&nbsp;</P><P>So, what should I do? Maybe some other mask with putc()? Maybe trying to keep all "internal" tables working with utf-8 (since source and destination uses that encoding)?</P><P>&nbsp;</P><P>Please help!</P><P>&nbsp;</P><P>Regards</P> Wed, 25 Mar 2020 16:02:19 GMT https://communities.sas.com/t5/SAS-Programming/UTF-8-in-Data-Integration/m-p/634804#M188416 pabloh2000 2020-03-25T16:02:19Z https://communities.sas.com/t5/SAS-Programming/UTF-8-in-Data-Integration/m-p/634882#M188460 What session encoding is the SAS session that is running DI using? You probably need to be using UTF-8. Wed, 25 Mar 2020 20:17:22 GMT https://communities.sas.com/t5/SAS-Programming/UTF-8-in-Data-Integration/m-p/634882#M188460 Tom 2020-03-25T20:17:22Z https://communities.sas.com/t5/SAS-Programming/UTF-8-in-Data-Integration/m-p/634883#M188461 How can I check that from Data Integration IDE?<BR /> Wed, 25 Mar 2020 20:20:05 GMT https://communities.sas.com/t5/SAS-Programming/UTF-8-in-Data-Integration/m-p/634883#M188461 pabloh2000 2020-03-25T20:20:05Z