ODK form title in other language showing as ? in aggregate and collect get blank forms list

Support
,
1

I wanted to give form title is Hindi language instead of english , in xlsform I give 'Monthly Reporting (मासिक रिपोर्टिंग)' in form_title in settings .
When I convert it to xlm and upload to aggregate the hindi part of name is showing just as 'Monthly Reporting (????? ??????????)' in both aggregate and collect app get blank forms list.
Its showing fine in fill blank form in collect app.

I am using v2.0.5 Aggregate

Screenshot from 2020-08-20 12-54-38
Screenshot from 2020-08-20 12-54-381600×900 124 KB

b8840649-71ee-46aa-91f5-d416c18d3d0c
b8840649-71ee-46aa-91f5-d416c18d3d0c540×1170 33.2 KB

Please suggest any solution.

2

Hi @Adarsh_Bisht
could you attach your form so that we can test it?

3

form.xlsx (77.1 KB)

Please find attached the form

4

There might be something wrong with your fork (I see you have your own customized app) because in the original app it looks fine:
image

5

Hi, Only the images of the collect app are customized , but even the aggregate is also showing same thing which is not customized at all.

6

This is a Unicode issue, @Adarsh_Bisht. You likely don't have the underlying MySQL database that Aggregate uses configured properly. See Enter/Input Bangla text in ODK Collect - #2 by yanokwa for an example of what your mysqld config should look like.

7

That was it ,Thanks !!