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 ?

3 answers

Mykhailo Halaida Mykhailo Halaida Flexmonster July 30, 2020

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,

Mykhailo Halaida Mykhailo Halaida Flexmonster August 6, 2020

How are you?
We were wondering if you’ve found our response helpful. Have you managed to overcome the mentioned issue, or is there still anything we can assist you with?
Please let us know what you think.

Mykhailo Halaida Mykhailo Halaida Flexmonster August 13, 2020

Hope you’re doing well!
Just checking in to ask whether you’ve had a chance to check out our response. Was it helpful, or do you still have any questions we can help you with?
We would be happy to hear your feedback.
Best regards,

Please login or Register to Submit Answer