Welcome to Geeklog Thursday, May 23 2013 @ 07:39 PM EDT
|
||||||||
![]() |
Forum Index > Support > Installation Support |
New Topic
|
Post Reply
|
UTF-8 |
|||
| Zippo |
|
||||||
![]() ![]() ![]() ![]() ![]() Chatty ![]() Status: offline ![]() 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. -=-=-=-=-=- |
||||||
|
|||||||
| Laugh |
|
||||||
![]() ![]() ![]() ![]() ![]() Admin ![]() Status: offline ![]() Registered: 09/27/05 Posts: 876 |
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. PHP 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 |
||||||
|
|||||||
| Zippo |
|
||||||
![]() ![]() ![]() ![]() ![]() Chatty Status: offline ![]() 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 |
||||||
|
|||||||
| Zippo |
|
||||||
![]() ![]() ![]() ![]() ![]() Chatty Status: offline ![]() 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. |
||||||
|
|||||||
| ::Ben |
|
||||||
![]() ![]() ![]() ![]() ![]() Full Member ![]() Status: offline ![]() Registered: 01/14/05 Posts: 1359 |
We speak french on http://geeklog.fr |
||||||
|
|||||||
| Zippo |
|
||||||
![]() ![]() ![]() ![]() ![]() Chatty Status: offline ![]() 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. |
||||||
|
|||||||
| Laugh |
|
||||||
![]() ![]() ![]() ![]() ![]() Admin ![]() Status: offline ![]() Registered: 09/27/05 Posts: 876 |
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.
|
||||||
|
|||||||
| Zippo |
|
||||||
![]() ![]() ![]() ![]() ![]() Chatty Status: offline ![]() 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) |
||||||
|
|||||||
| Content generated in: 0.56 seconds |
|
|
|