Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
103 | |
101 | |
84 | |
77 | |
66 |
User | Count |
---|---|
135 | |
109 | |
104 | |
83 | |
73 |