Enter/Input Bangla text in ODK Collect

Dear Community,

Is it possible to enter non English text into ODK Collect and safely preview the output from MySQL database? Do we need to make any changes in the XLS specifying the input language?

At database I assume we need to change the table characterset to UTF-8 and Collate to UTF-8-GENERAL-CI to support necessary characters for a different language.

Thanks for the support.

Regards,
Ayub Zafar

If the non-English text you are typing is Unicode safe, then yes, it'll work without any changes to the form or Collect.

Your MySQL DB will need to have utf8_unicode_ci because utf8_general_ci sorting is broken. Here's what my config looks like.

[mysqld]
character-set-server=utf8
collation-server=utf8_unicode_ci
max_allowed_packet=1073741824

I strongly recommend you try this setup first before rolling it out into production.

1 Like