Viewing Korean Characters in Information Analyzer
Posted: Thu Dec 18, 2008 12:57 pm
I have a Information Analyzer issue. The data is from Oracle table and is Korean characters stored as UTF 8 in oracle table
When I import the data in excel it looks Korean as normal ( 3rd column below is NAME field)
1 100 대표 2008-12-18 08:56:54
1 101 안중태 2008-12-18 08:56:54
1 102 천정균 2008-12-18 08:56:54
1 103 이숙자 2008-12-18 08:56:54
1 104 김형래 2008-12-18 08:56:54
1 105 하현준 2008-12-18 08:56:54
1 106 김연규 2008-12-18 08:56:54
1 107 채희권 2008-12-18 08:56:54
1 108 김용애 2008-12-18 08:56:54
1 109 허성 2008-12-18 08:56:54
When I import and run column analyzis on the above table ( first 3 columns) then it does the column analzis just fine but when I view or drill data it does not show Korean characters and also I do not believe it gives the <b>cardinality accurately for the Name coulmn</b>
Is there a specific process to be followeed for profiling foriegn langauge data stored as UTF8
We do have NLS installed on the server.
In fact this data file is created by a job using the UTF-8 character map
Please advice
When I import the data in excel it looks Korean as normal ( 3rd column below is NAME field)
1 100 대표 2008-12-18 08:56:54
1 101 안중태 2008-12-18 08:56:54
1 102 천정균 2008-12-18 08:56:54
1 103 이숙자 2008-12-18 08:56:54
1 104 김형래 2008-12-18 08:56:54
1 105 하현준 2008-12-18 08:56:54
1 106 김연규 2008-12-18 08:56:54
1 107 채희권 2008-12-18 08:56:54
1 108 김용애 2008-12-18 08:56:54
1 109 허성 2008-12-18 08:56:54
When I import and run column analyzis on the above table ( first 3 columns) then it does the column analzis just fine but when I view or drill data it does not show Korean characters and also I do not believe it gives the <b>cardinality accurately for the Name coulmn</b>
Is there a specific process to be followeed for profiling foriegn langauge data stored as UTF8
We do have NLS installed on the server.
In fact this data file is created by a job using the UTF-8 character map
Please advice