Geeklog Forums

We recently migrated from a very old version of Geeklog (1.3.7sr3, I think) to 1.4.0sr3, and most everything seems to have worked ... except for the conversion of special characters in both comments and usernames (and probably any other field where they might have existed).

For instance, if a user's account name was "Jévonne," it now shows up as "Jétonne," and the user obviously can't login. I've compared the header.thtml and config.php files from before and after the upgrade, and I don't see any obvious setting I may have overlooked.

Help!?

-rob.

Follow up: The data in the MySQL file itself seems to be fine. If I connect directly via mysql and run the query:

select * from users where username='Jévonne'

Then I find the account. But if I use the Geeklog search field on users, I can only find a match if I search for "Jévonne".

So our data is fine, it's just the display that's messed up.

-rob.

Sounds more like a character set issue - UTF-8 vs. ISO-8859-1.

bye, Dirk

It does seem to be a character set issue. Now we're trying to figure out why .

-rob.

Solved. But the cause and solution might be worth sharing. We had, we thought, properly set the charset in the config.php ... but we didn't understand that the english.php file in the language directory *also* set the charset, and that its value overrode that of config.php.

RTFM, I know.

-rob.