Welcome to Geeklog, Anonymous Wednesday, July 09 2025 @ 01:33 am EDT
Geeklog Forums
UTF-8
Status: offline
Forum User
Chatty
Registered: 07/08/11
Posts: 53

FYI
After I installed the dokuWiki plugin, I could not make a proper Wiki while my special characters did not converted properly by DokuWiki.
Dokuwiki Forum support, told me to change the browser setting to UTF-8. No result.
This evening:
I renamed the geeklog language file dutch.php into dutch_org.php.
I copied the geeklog language file dutch_UTF8.php into dutch.php.
Problem Solved!
-=-=-=-=-=-
But was this the right way I supposed to do it?
I could nowhere find an option in geeklog configuration panel to choose UTF-8.
Also in My account / language list... only 1 dutch language.
-=-=-=-=-=-
After I installed the dokuWiki plugin, I could not make a proper Wiki while my special characters did not converted properly by DokuWiki.
Dokuwiki Forum support, told me to change the browser setting to UTF-8. No result.
This evening:

I renamed the geeklog language file dutch.php into dutch_org.php.
I copied the geeklog language file dutch_UTF8.php into dutch.php.
Problem Solved!
-=-=-=-=-=-
But was this the right way I supposed to do it?
I could nowhere find an option in geeklog configuration panel to choose UTF-8.
Also in My account / language list... only 1 dutch language.
-=-=-=-=-=-
16
19
Quote
Status: offline
Site Admin
Admin
Registered: 09/27/05
Posts: 1475
In step 2 of the Geeklog install is the option to select UTF-8.
To manually change it for a site you are already running you will have to edit siteconfig.php found in the public_html directory.
You should also then convert your database to utf-8. Take a look at this article. There also was a good forum post about this from a few years ago but I can't seem to find it at the moment.
Tom
To manually change it for a site you are already running you will have to edit siteconfig.php found in the public_html directory.
Text Formatted Code
$_CONF['default_charset'] = 'utf-8';You should also then convert your database to utf-8. Take a look at this article. There also was a good forum post about this from a few years ago but I can't seem to find it at the moment.
Tom
15
17
Quote
Status: offline
Forum User
Chatty
Registered: 07/08/11
Posts: 53
Thanks....
I searched on "utf_8", that's why I missed it
Ok.. have some work tot do...
Thanks again,
Grtz.
Zippo
I searched on "utf_8", that's why I missed it

Ok.. have some work tot do...

Thanks again,
Grtz.
Zippo
12
19
Quote
Status: offline
Forum User
Chatty
Registered: 07/08/11
Posts: 53
Hmmm....
When I click on localhost in myphpadmin, I see:
==================
Server: Localhost via UNIX socket
Serverversie: 5.0.92-community
Protocolversie: 10
User: xxxxxxx@localhost
MySQL Karakterset: UTF-8 Unicode ( utf8 ) (Note: I did not changed it, was already like this)
===========
But In All the databases/tables I see: "latin1_swedish_ci" everywhere..
Should I change this??
So yes....
Can somebody post a query to run... or post a solution to change this in a batch.
When I click on localhost in myphpadmin, I see:
==================
Server: Localhost via UNIX socket
Serverversie: 5.0.92-community
Protocolversie: 10
User: xxxxxxx@localhost
MySQL Karakterset: UTF-8 Unicode ( utf8 ) (Note: I did not changed it, was already like this)
===========
But In All the databases/tables I see: "latin1_swedish_ci" everywhere..
Should I change this??
So yes....
Can somebody post a query to run... or post a solution to change this in a batch.
18
17
Quote
Status: offline
Forum User
Chatty
Registered: 07/08/11
Posts: 53
Sorry Ben,
That is not a tutorial, but a puzzle in Chinese for me.
(BTW. I can not read Chinese)
Geeklog = dutch_utf8 now.
Only all the SQL tables give latin.... (and I have over a hondred tables)
Tutorial says: I used the "replace commando" but does not say how to use it.
Just type:
REPLACE latin1_swdish_ci UTF-8 Unicode
Won't work, at least I am afraid to experiment with it.
-=-=-=-
It looks that everything works fine.
That is not a tutorial, but a puzzle in Chinese for me.
(BTW. I can not read Chinese)
Geeklog = dutch_utf8 now.
Only all the SQL tables give latin.... (and I have over a hondred tables)
Tutorial says: I used the "replace commando" but does not say how to use it.
Just type:
REPLACE latin1_swdish_ci UTF-8 Unicode
Won't work, at least I am afraid to experiment with it.
-=-=-=-
It looks that everything works fine.
15
15
Quote
Status: offline
Site Admin
Admin
Registered: 09/27/05
Posts: 1475
Is this a new site? If so it would be better to just copy the information you need and then just delete the database and start fresh.
15
19
Quote
Status: offline
Forum User
Chatty
Registered: 07/08/11
Posts: 53
It is a fairly new site.
I have no strange characters anymore... so I will change the table settings in slow manual mode. (no hurry)
But I will not install GeekLog for the 4th time (twice: I have 2 sites running)
I have no strange characters anymore... so I will change the table settings in slow manual mode. (no hurry)
But I will not install GeekLog for the 4th time (twice: I have 2 sites running)

15
17
Quote
All times are EDT. The time is now 01:33 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content