Text characters change after import?
Just installed Elkarte using Open Importer from an SMF 2.0.17 board.
The import went well and the board is up and running with the latest Elkarte 1.1.6 version. The only problem that I have found is a that some of the text characters have changed. See photo which shows the problem, is there a setting that I can change to correct this?
Re: Text characters change after import?
Reply #2 –
Everything seems to be in order and all elkarte db files are UTB8.
It's not a major problem there are only a few text character errors, and these are editable.
Re: Text characters change after import?
Reply #3 –
After discovering many other broken text characters on the board I carried out a further check through phpMyAdmin
The very bottom database file (collation) is stating 91 files are latin1_swedish_ci 98.9 MiB, all of the other files have a collation of utf8_general_ci. Could this be the problem?
Edit:
Correct image now added
Re: Text characters change after import?
Reply #6 –
Yep, that can happen. Elk uses UTF8 by default, which makes a lot of sense, but converting SMF 1.1.x or 2.0.x from ISO to UTF8 can cause glitches like this.
Honestly, fixing this is above my pay grade. You'll need someone who is more up to speed with database trickery. I'm sure there is a fix, because it's a reasonably common problem, but offhand I don't know what that fix is.