loading data from a flat file to table using informatica, having both english and foreign language characters like chinese

utf-8 character cjk informatica-powercenter
Walker picture Walker · Nov 16, 2009 · Viewed 13k times · Source

I am loading data from a flat file to table using informatica, the file has both english and foreign language characters like Chinese, and others. The foreign language characters are not getting displayed properly after loading. How can this problem be solved? I could try to solve it by using UTF-16 encoding, but earlier I was using UTF-8.

Answer

Meitham picture Meitham · Jan 13, 2012

You need to find out the encoding for the Integration Service that runs the workflow of the loading. Informatica supports three different encoding for this, utf-8, ascii and windows-1252, you need to make sure yours is utf-8. You also need to tell the source qualifier for the workflow to use the right encoding to read the file (could be utf-8 or utf-16). And finally you must make sure your database tables are using an encoding that supports chinese.

Related questions

How many characters can be stored in 4KB?

How many characters can i store in 4kb when the characters are in utf-8 encoding ?

Read More
Character with encoding UTF8 has no equivalent in WIN1252

I am getting the following exception: Caused by: org.postgresql.util.PSQLException: ERROR: character 0xefbfbd of encoding "UTF8" has no equivalent in "WIN1252" Is there a way to eradicate such characters, either via SQL or programmatically? (SQL solution should be …

Read More
What is the maximum number of bytes for a UTF-8 encoded character?

What is the maximum number of bytes for a single UTF-8 encoded character? I'll be encrypting the bytes of a String encoded in UTF-8 and therefore need to be able to work out the maximum number of bytes for a …

Read More