Mysql native query getting special characters in column names

[pmargari]

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

[Anonymous]

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.

[lbendlin]

looks like somewhere you are missing the UTF-8 (65001) setting

[pmargari]

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 

[lbendlin]

latin1 is your problem. Change to utf-8.