Connect to local csv files encoding with cp949

Answered
SeKyoung asked on August 19, 2022

Hello,
When I connect to local csv files encoding with cp949(we call it MS949 or WINDOWS949 too),
it doesn't work well as attached the screen shot.
If there are a few files with cp949, I can change the encoding with Excel or Notepad++, but that cannot be the solution in our situation.
All files are not cp949, most of them are utf-8.
I've looked for similar cases at help center and found one "https://www.flexmonster.com/question/how-to-add-arabic-language-support-to-flexmonster/".
I can't get how to fix it with that.
Could you elaborate a bit?
Which file should I modify and how to. etc...
I'm looking forward to getting your answer.
Best your regards,
SK Park.

Attachments:
csvtest.csv

6 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster August 19, 2022

Hello,

Thank you for reaching out to us.

Our team is currently working on your question. We will get back to you soon.

Kind regards,
Nadia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster August 23, 2022

Hello!
 
Thank you for giving us some time for the research.
 
Kindly note that the approach suggested in the ticket you've found on the Help Center(https://www.flexmonster.com/question/how-to-add-arabic-language-support-to-flexmonster/) wouldn't work for the cp949 encoded files.
The cp949 encoding is not registered with IANA as a standard to communicate information over the Internet. Therefore, not all browsers support it and display the characters correctly.
 
The simpler workaround we can advise is to change the files' encoding manually or programmatically before sending them to the client-side of the application. 
For example, you can use the Python plugin of Notepad++ for the conversion: https://stackoverflow.com/questions/35526466/notepad-convert-to-utf-8-multiple-files.
 
Hope you will find our answer helpful. 
Feel free to contact us in case of any other questions.
 
Best regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster August 30, 2022

Hello!

Hope you are doing well.

Our team is wondering if you had some time to check out the suggested approach and change the encoding. Could you please let us know if it works?

Looking forward to your response.

Regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster September 6, 2022

Hello!

Hope you are having a great week.

Just checking in to ask if the suggested approach was helpful in changing the encoding.

Looking forward to your response.

Regards,
Solomiia

Public
SeKyoung September 13, 2022

Hi!  Solomiia,
I'm sorry for the late reply.
The way you presented was helpful.
It was also very helpful to know that cp949 is not registered with IANA and not all browsers support it.
We'll convert to utf-8 through Notepad++ or another text editor manually or programmatically.
Thank you very much.
Regards,
SK Park
 
 
 

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster September 13, 2022

Hello!

Thank you for your feedback.

We are glad to hear that our answer was helpful.

Feel free to contact us in case of any other questions.

Regards,
Solomiia

Please login or Register to Submit Answer