使用 informatica 将数据从平面文件加载到表中,同时具有英语和外语字符(如中文)
我正在使用 informatica 将数据从平面文件加载到表中,该文件同时包含英语和外语字符,如中文等。加载后外语字符无法正确显示。如何解决这个问题呢? 我可以尝试使用 UTF-16 编码来解决这个问题,但之前我使用的是 UTF-8。
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.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
从设计器中的源开始。您能否在源限定符预览中正确看到数据?如果没有,您可能需要将 ff 源定义编码设置为 UTF-8。
集成服务应在 Unicode 模式而不是 ASCII 模式下运行。您可以从管理控制台中的集成服务属性中进行检查。
目标应该是 UTF-8 编码。
Sadagopan
Start with the Source in designer. Are you able to see the data correctly in the source qualifier preview? If not, you might want to set ff source definition encoding to UTF-8.
the Integration service should be running in Unicode mode and not ASCII mode. You can check this from the Integration service properties in Admin Console.
The target should be UTF-8 encoding.
Sadagopan
您需要找出运行加载工作流程的集成服务的编码。 Informatica 支持三种不同的编码:utf-8、ascii 和 windows-1252,您需要确保您的编码是 utf-8。您还需要告诉工作流的源限定符使用正确的编码来读取文件(可以是 utf-8 或 utf-16)。最后,您必须确保您的数据库表使用支持中文的编码。
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.