Recently I've noticed my forum has an issue with member posts where they are using apostrophes and single or double quotation marks. Interesting part is that it one poster has no problems, another has and on the same topic.
Example:
I've turnes into I?ve etc...
Any idea what is causing this?
Forum Version:
SMF 2.0.17
Ad Managment 3.5c
Copyright and Footer Links 3.2
Simple Audio Video Embedder 5.0.5
Menu Editor Pro 1.0.1
Anti-spam by CleanTalk 2.31
Awesome Post Ratings 1.0.2
Google Analytics Code 1.5.1
change your forum over to UTF8
Just ran a UTF-8 conversion.... all table are now utf8_general_ci .
Hopefully this will make the problem go away.
MH
make sure the forum itself is set to UTF8, in addition to the database tables (including language files are also using rthe UTF8 versions...)
Quote from: Kindred on April 01, 2020, 03:29:51 PM
make sure the forum itself is set to UTF8, in addition to the database tables (including language files are also using rthe UTF8 versions...)
You lost me on that one. Where do I set the forum to UTF8?
In addition to the tables, there are two important settings.
In Settings.php, you should see an entry for:
Quote$db_character_set = 'utf8';
In the settings table, there should be an entry for:
variable | value |
global_character_set | UTF-8 |
If you used the SMF function to convert to UTF8 (found under Admin | Maintenance | Forum Maintenance | Database | Convert the database and data to UTF-8) you are OK, this will fix your settings.
Sometimes folks just change the tables, but without the settings in alignment as well, you will still see problems.
Thank you. I used the SMF function to convert and I checked settings.php.
All good.