Script to convert to UTF-8 The database for my Phorum is in latin1_danish_ci, and I was hping to get it to work properly with UTF-8. I've tried a few things, but I can't get it to work. Maurice Makaay once wrote a script which was located at this address: [secretsauce.phorum.org] ...but it is no longer available. Perhaps somebody has a copy of it? Not sure it would solve my problem, but perhaps worth a try. My goal is to be able to use full multibyte UTF-8 characters, like this: ???? ord nr17 - 5/6 ????⬜⬜⬜⬜ ⬜⬜????⬜⬜ ????????????⬜???? ⬜???????????????? ???????????????????? www.wordle.lol On my phorum, when trying to post this, I end up with a database error: Illegal mix of collations (latin1_danish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (1267):...... https://www.phorum.org/phorum5/read.php?61,162679,162679#msg-162679 Sat, 14 Mar 2026 01:34:20 -0400 Phorum 5.2.22 https://www.phorum.org/phorum5/read.php?61,162679,162681#msg-162681 Re: Script to convert to UTF-8 https://www.phorum.org/phorum5/read.php?61,162679,162681#msg-162681 www.phorum.org]

Do a search on "script" All Dates
or "Unicode" All Dates

OR
Export your data, change the import to UTF-8 (not sure this spelling) is correct for php & mysql import to a new clean database that stores the way you want. Test, if good make live.

Phorum sanitizes some things differently on preview. Don't know why.]]> Scott Finegan 5.2 Phorum Support Sat, 12 Feb 2022 13:59:18 -0500 https://www.phorum.org/phorum5/read.php?61,162679,162680#msg-162680 Re: Script to convert to UTF-8 https://www.phorum.org/phorum5/read.php?61,162679,162680#msg-162680
For reference, it should have looked like this:

]]> mroek 5.2 Phorum Support Sat, 12 Feb 2022 09:24:31 -0500 https://www.phorum.org/phorum5/read.php?61,162679,162679#msg-162679 Script to convert to UTF-8 https://www.phorum.org/phorum5/read.php?61,162679,162679#msg-162679
Maurice Makaay once wrote a script which was located at this address:

[secretsauce.phorum.org]

...but it is no longer available. Perhaps somebody has a copy of it? Not sure it would solve my problem, but perhaps worth a try.

My goal is to be able to use full multibyte UTF-8 characters, like this:

???? ord nr17 - 5/6
????⬜⬜⬜⬜
⬜⬜????⬜⬜
????????????⬜????
⬜????????????????
????????????????????
www.wordle.lol

On my phorum, when trying to post this, I end up with a database error:

Illegal mix of collations (latin1_danish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (1267):......]]> mroek 5.2 Phorum Support Sat, 12 Feb 2022 09:22:16 -0500