For a project we collect international data including Korean. Since 2016 I could read the Excel files with Korean Characters into SPSS (sometimes by using ACCESS as in between).
Last week I received a new Korean file and SPSS does not read the Korean Characters anymore. I have converted the data to CSV (ASCII and UTF8), ACCESS (ODBC connection to SPSS), OXML, but SPSS 24 thru 27do not read the Korean Characters anymore. Not even with the older data I could read into SPSS. Does anyone encounter this problem? Does anyone know of a solution?
It could also be solved if I could Romanize the Korean Characters in ACCESS or EXCEL. Does anyone know of a solution of converting a column/field with Korean Characters into a column/field with Romanized Characters?
I had same problem with Turkish characteristics, I think SPSS doesn't support non English anymore, but I am not sure!
True, but in the age of Big Data, this is extremely annoying. Tried reading the file into R and it appeared the codes were UTF-8. I use SPSS with UTF-8 in my data and in the syntax files, but it all has gone. It might also be a problem with Windows 10. Maybe some strange update has caused a problem. Maybe MS has changed to a different style of UTF, maybe UTF-16.
Try changing your Windows User Locale to Korean, which you can do via the Regional Options in the Control Panel
Gaihemlung Pamei , I am not sure I want to change my Windows to Korean. It is does not seem the problem. All Office (Windows) products can read the Korean Characters, but SPSS and R can not reproduce them. The problem might be with the double precision required to show Korean and Chinese characters correctly.
Louai Alsaloumi , did your problem start after installing the new accessdatabaseengine instead of the original ODBC driver? If that would be the case, it might be Microsoft have messd up the driver.
- Badges
- Science topic
- Similar topics
- Filing