Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
We have setup a new Mysql server , we have checked all the settings and made equal to an existing one.
When we make a native mysql query now we get special characters in the column names , the bellow image show as we see the column names in the mysql and how we see after we run the native query with a simple select ......
Any clue what could be the issue ?
Thanks
Paulo
Hi @pmargari ,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
looks like somewhere you are missing the UTF-8 (65001) setting
Thanks for your repply.
The new server is azure flexible server MySQL and I can't see any settings that relates to UTF-8
What we have and as in the previous server is :
show variables like "character_set_database" = latin1
this only happen with the column headers not the data in the tables
Headers :
Row Data :
Thanks
latin1 is your problem. Change to utf-8.