Page 1 of 1

Characters not showing well

Posted: Fri Aug 03, 2018 1:05 pm
by antonios
Hi,
I did an upgrade to J1.5.26 (before upgrading to J3.8.x..the next step) and some of the special characters, like accents, tilde, etc. don't appear well. There must be an issue with the UTF coding I guess but I am not sure how to fix it.
Can anyone help?
Regards

Re: Characters not showing well

Posted: Sat Aug 04, 2018 2:28 pm
by ltheme
You should recheck font in template and make sure that it still supports.

Re: Characters not showing well

Posted: Sun Aug 05, 2018 4:03 pm
by antonios
Hi, I am not sure how to do this. I do not see any reference to the font in the template files
can you help?
Regards

Re: Characters not showing well

Posted: Sun Aug 05, 2018 5:55 pm
by Per Yngve Berg
https://docs.joomla.org/Web_page_diagnostic_tools

What version did you have before 1.5.26?

Re: Characters not showing well

Posted: Sun Aug 05, 2018 6:26 pm
by antonios
1.5.21

Re: Characters not showing well

Posted: Sun Aug 05, 2018 6:39 pm
by Per Yngve Berg
There are no changes regarding character sets.

Re: Characters not showing well

Posted: Sun Aug 05, 2018 7:39 pm
by antonios
So...what can I do then?
You can have a look at my website to see the actual problem. Here and there the special characters are replaced by a "?"
http://www.permacultura-es.org/index.php

Re: Characters not showing well

Posted: Mon Aug 06, 2018 3:04 am
by ltheme
Look like it's problem with Database format, make sure that your database (mySQL or SQLServer) support UTF-8 Unicode CI (utf8mb4_unicode_ci).

Re: Characters not showing well

Posted: Mon Aug 06, 2018 12:50 pm
by antonios
If I look at the top of the database (mysql) through phpmyadmin, I can see that the database general settings are with utf8mb4_unicode_ci.
db1.png
However, many tables have either "latin1_swedish_ci" or utf8_general_ci on their collation property
db2.png
Is this normal?

On the other hand, before upgrading to 1.5.26 I unistalled a number of extensions but their tables are still in the database, is this normal?