Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
Get Free Trial

Data server – Mysql Query encoding

Seekme asked on July 29, 2020

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 ?

1 answer

Mykhailo Halaida Mykhailo Halaida Flexmonster 7 days ago

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 tag:

<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.
Best regards,

Please login or Register to Submit Answer