All geek questions in one place

Loading data from a flat file into a table using informatica, which has both English and a foreign language, such as Chinese

I load data from a flat file into a table using informatica, the file has both English and foreign characters, such as Chinese and others. After loading, foreign language characters are not displayed correctly. How to solve this problem? I could try to solve this problem using UTF-16 encoding, but I used to use UTF-8 before.

+3
source share
2 answers

  • Start with the source in the designer. Can you see the data correctly in the source preview? If not, you can set the source ff encoding to UTF-8.

  • The integration service must be in Unicode mode, not ASCII mode. You can verify this from the Integration service properties in the admin console.

  • The target must be UTF-8 encoded.

    • Check the relational connection (if the target is a database) in the workflow manager to make sure it is UTF-8
    • If the problem persists, write the output to utf-8 and verify that the data is loaded correctly. If so, then the problem is with writing to the database.
    • Check database settings such as NLS_LANG, NLS_CHARACTERSET (for oracle), etc.

Sadagopan

+1
source

, . Informatica : utf-8, ascii windows-1252, , utf-8. ( utf-8 utf-16). , , , , .

+1

Source: https://habr.com/ru/post/1722970/

More articles:


All Articles