CODEWITHSUNDEEP
azureazure-mysql-database
Sebastian
Sebastian

Reputation: 4811

Azure MySQL flexible server showing special characters as codes

After a new instance of Azure MySQL flexible server is setup, i imported data from existing mysql data base using Heidi and it looks like all data is imported but after a deeper look , realised that all the apostrophes, ampersands, etc are now displaying as code on the web page like below

Original text: ‘Green’ light for world’s first
Azure Mysql text: â€Green†light for worldâ€s first

Checked the following settings on both instance and it is the same value across all servers

 SELECT @@character_set_database, @@collation_database; 
 
 utf8mb4  && utf8mb4_0900_ai_ci

Is there any other settings need to be verified at time of import

Upvotes: -1

Views: 267

Answers (1)

user3414775
user3414775

Reputation: 11

Append charset=utf8mb4 in dbconnection string

Example:

string connectionString = "server=<server_name>;port=<port_number>;database=<database_name>;uid=<username>;password=<password>;charset=utf8mb4;";

Upvotes: 1

Related Questions