PDA

View Full Version : Problem whith character


Mandushi
07-18-2019, 03:28 PM
. I am reaching out to ask for your help regarding an issue I am encountering with my forum. A couple of weeks or so ago we upgraded the forum from 3.8.9 to the 3.8.11 version. We also moved the forum to a new server. We are now seeing an issue that when some users post the characters “ë” and “ç”, they now show with the following symbols: ë ç
I have no idea how to this since I am not the best at this kind of stuff. Could you please help? Thanks so much

snakes1100
07-18-2019, 08:06 PM
Fix your character collation on the server so they all match.


character_set_client latin1
character_set_connection latin1
character_set_database latin1
character_set_results latin1
character_set_server latin1

Mandushi
07-18-2019, 09:07 PM
In my server is

character_set_client latin1
character_set_connection latin1
character_set_database utf8
character_set_filesystem binary
character_set_results latin1
character_set_server latin1
character_set_system utf8


How can i fixed it ?

snakes1100
07-19-2019, 06:49 AM
How about these?


collation_connection latin1_swedish_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci


What is the php info display?
default_charset UTF-8 UTF-8

Mandushi
07-19-2019, 08:20 AM
collation_connection latin1_swedish_ci
collation_database utf8_general_ci
collation_server latin1_swedish_ci

Php info

default_charset UTF-8 UTF-8