Importing data in multiple languages

2 posts / 0 new
Last post
sng1017
Offline
Joined: 01/17/2023 - 01:50
Importing data in multiple languages

Hi guys,
 
Have anyone ever tried to use Import Assistant/ReportReader to import a file which is mainly in English language but also consists foreign languages (Chinese, Japanese eg)? Some data in these foreign languages became unreadable characters in the output. 
 
Appreciate any inputs on how I can keep them in the original language(s) or any workaround I haven't thought of.
 

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

IDEA comes in two version, namely the ASCII and Unicode versions.  It sounds like you are using the ASCII version when you should probably be using the Unicode version if you are dealing with Chinese and Japanese character sets.