Portal Home > Knowledgebase > Articles Database > Special Character Issues
Special Character Issues
| Posted by Zieg, 09-26-2014, 09:38 AM |
| Special Character Hell
I have tried a bunch of things to solve it server-wide, but I really couldn't get it to work properly.
Do you know a way to get characters like á, ë, õ, ç, ñ to work properly server-wide?
In the "my.cnf"" at /etc/ as well at /usr/, we have:
In the "php.ini" at /usr/local/lib/ we have:
Even when I ensure a database is created with the proper charset and collate set for example as utf8mb4 and utf8mb4_unicode_ci, on most stuff I get this sort of data in the DBs:
The characters above are the same as in our example.
Thereafter, it should be:
á, ë, õ, ç, ñ
Not:
á, ë, õ, ç, ñ
What exactly is going on this case?
What can be done to definitely solve these issues server-wide?
Regards,
Zieg
Last edited by Zieg; 09-26-2014 at 09:42 AM.
Reason: typos
|
| Posted by net, 09-26-2014, 10:09 AM |
| Moved > Hosting Security and Technology.
|
| Posted by Zieg, 09-26-2014, 12:57 PM |
| You guys deal with this all day and night long, and no one have an idea about what is going on, and how to solve it?
I see that if I paste the characters in this online tool, and hit the UTF-8 to Latin (ISO 8859-1) the characters appears correctly. In any way, they are stored incorrectly in the database somehow from what I saw...
Could someone share some ideas?
Thanks in advance,
Last edited by Zieg; 09-26-2014 at 01:04 PM.
Reason: Adding more info
|
| Posted by Zieg, 09-26-2014, 07:16 PM |
| The main issues are with WordPress, specifically with themes and plug-ins. Wordpress alone seems to be working fine, but as soon as it gets some themes and plug-ins, some of it doesn't do well.
Horde mail is also having issues.
I can ensure all the databases are with the proper character set, as well the proper collation. All the tables was double-verified for it as well. Anyway issues persists mainly in languages like Spanish, Portuguese, French, Russian...
Thereafter, I'm not sure how to proceed to solve it server-wide, in a manner these problems doesn't keep recurring: I mean, whenever someone set-up a WordPress site, it should work out of the box with those and other languages since MySQL is using the UTF8mb4, databases are being created with these character set as well the tables. So, I think that since everything was set as UTF8mb4, it should work fine without issues.
I'm in a lost, and not really sure if it would be possible and how to proceed in a manner to ensure it now and in the future.
Anyone?
Thanks again,
Last edited by Zieg; 09-26-2014 at 07:25 PM.
Reason: More info
|
| Posted by Zieg, 09-26-2014, 08:24 PM |
| Just to be even more specific...
Characters are input the contact form in a WordPress this way:
á, ë, õ, ç, ñ
They are being stored in the database and displayed this way:
á, ë, õ, ç, ñ
If I paste the above result on this tool, and hit the UTF-8 to Latin (ISO 8859-1) the characters appears correctly back to:
á, ë, õ, ç, ñ
Additionally, I'm not sure if there is any issue with double encoded characters and if it has something to do with the issues on this node. Probably some of you would know it pretty better than I would in the coming five years.
This is what is going on with a few things on this server, and any advice considering what have been told would be pretty welcome.
|
Add to Favourites 
Print this Article
Also Read
Shared Hosting
Shared Hosting
