Forum Stats

  • 3,757,062 Users
  • 2,251,193 Discussions
  • 7,869,716 Comments

Discussions

Encoding UTF16 from a flat file

User_Y6T3P
User_Y6T3P Member Posts: 4 Green Ribbon
edited Jun 8, 2021 11:14PM in Data Integrator

I have a flat file which contain such character ʔaq̓am and Sq'éwlets then after mapping in ODI and querying in oracle sql developer tool, the result would be ¿aq¿am and Sq'éwlets

I saw these posts + documents

https://docs.oracle.com/middleware/1212/odi/ODIKM/files.htm#ODIKM466

https://www.eehelp.com/question/unicode-conversion-utf8-in-odi/

which then I added encoding to my jdbc url which would then look like jdbc:snps:dbfile?ENCODING=UTF8 and then Sq'éwlets would look perfectly fine after encoding, but the other one ʔaq̓am would still look like ¿aq¿am

So I thought UTF8 might not be enough that I should try UTF16 so I had jdbc:snps:dbfile?ENCODING=UTF16 but this actually made it worse it's seeing all the values in the column as null.

Anyone has idea if there's something else I need to change in settings or in mapping for the encoding to work?


P.S. in database, the field is using nvarchar2 as data type

Tagged: