Problems with character_set coherence

[Ravallro]

Website URL

https://rvalldecabres.great-site.net

Other Information

After creating my database (importing from localhost built with XAMPP) I obtain
these:

SHOW SESSION VARIABLES LIKE ‘character_set_%’ results in:
character_set_client utf8mb4
character_set_connection utf8mb4
character_set_database latin1
character_set_filesystem binary
character_set_results utf8mb4
character_set_server latin1**
character_set_system utf8

SHOW SESSION VARIABLES LIKE ‘collation_%’
collation_connection utf8mb4_unicode_ci
collation_database latin1_swedish_ci**
collation_server latin1_swedish_ci**

The same commands in localhost

SHOW SESSION VARIABLES LIKE ‘character_set_%’;
character_set_client utf8mb4
character_set_connection utf8mb4
character_set_database utf8mb4
character_set_filesystem binary
character_set_results utf8mb4
character_set_server utf8mb4
character_set_system utf8

SHOW SESSION VARIABLES LIKE ‘collation_%’;
collation_connection utf8mb4_unicode_ci
collation_database utf8mb4_general_ci
collation_server utf8mb4_general_ci

I had no problems of visualizing characters like À, é in localhost.
But problems appers in my web site. I do not visualize À, é and also do not obtain the same response in SQL statements including _
I guess the reason is incoherence in shown parameters.

[KangJL]

Please read

Display UTF-8 from database

If the data is read from the database, please note that by default, database connections on our hosting do NOT use UTF-8 encoding, but latin1 instead. So if you enter special characters through phpMyAdmin (which does use UTF-8 connections) and then display it on your site, it will appear garbled. The same is true if you do the reverse (write from your site and display in phpMyAdmin). The fix is simple: you need to specify the connection character encoding in your PHP code. If you use MySQLi: P…

[Ravallro]

I tried what you said and the situation gets worst.
You can see what happens if you demand
https://rvalldecabres.great-site.net/dq/peticion3.php
Only a few ‘Notarios’ appears wrong (those which include Ç or ’ ).
If I change to utf8bm4 every Notario with an accent (í,á,à,é, etc) appears bad.

[Ravallro]

Thanks a lot for your indication.
I tried again from scratch (importing database again) and modifiy connections as you indicated ($con->set_charset(“utf8mb4”) and every thing is running OK.

[Admin]

Glad to hear you were able to get it resolved. But for you, or anyone else reading this, there is a knowledge base article about this with some more detail:

Garbled characters and question marks in database data

Are you coding your own website with PHP and MySQL? Did you create or upload some records through phpMyAdmin and trying to show them on your website? Or did you submit some data through your website and are trying to check it in phpMyAdmin? If so, you may have problems with special characters, i.e. all characters that are not standard letters, numbers or basic punctuation, including letters with accents, non-latin alphabets or emoji. Data submitted through phpMyAdmin may end up as question mark…