Language error in downloaded data

Support
1

What is the problem? Please be detailed.

I have programmed a questionnaire (English and Vietnamese language options). When I view questions in ODK Aggregate (online), responses appear in proper Vietnamese text.
However when I download the data, text in Vietnamese are now distorted by 'strange' characters.

Please find attached a file of the issue.

What ODK tool and version are you using? And on what device and operating system version?

I am using ODK Collect v1.16.2

What steps can we take to reproduce the problem?

What you have you tried to fix the problem?

Anything else we should know or have? If you have a test form or screenshots or logs, attach here.language error example.csv (887 Bytes)

2

This CSV works for me, so my guess is that you are double-clicking it and trying to open it with Excel.

That won't work because Excel has miserable UTF-8 support. If you are using Excel, try these instructions: https://www.itg.ias.edu/content/how-import-csv-file-uses-utf-8-character-encoding-0

Alternatively, try LibreOffice.

1 Like
3

Thank you for response Yaw. Issue is successfully resolved.