I’ve been using Data Server with Mysql query and it works nice, I have only ont hing I can’t solve : the column name with accent not displaying correctly accent.
I use something like SELECT pivot.region `Région` FROM pivot in flexmonster-config.json and it displays RÃ©gion.
So can I solve this using alias in my query and if not, how can I properly define my caption other than in my config.json ?
Thank you for posting your question.
This issue is most likely related to your encoding configurations – however, it is not very clear to us on which exact level of the application the issue begins. In case of client-side, it is usually enough to specify the encoding for your HTML page with the following
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
If the above does not help, it might be a good idea to check whether the encoding of your data is being handled incorrectly before it being transferred to Flexmonster.
Alternatively, you can also modify the captions for the fields on the client-side with the help of the Mapping Object. More specifically, the `caption` property of the corresponding field inside the Mapping Object can be used to set up a custom caption for the hierarchy.
Please let us know if this helps.