Topics

User Functions

Events

There are no upcoming events

What's New

Stories

No new stories

Comments last 2 weeks

No new comments

Trackbacks last 2 weeks

No new trackback comments

Links last 2 weeks

No recent new links

NEW FILES last 14 days

No new files

Welcome to Geeklog Thursday, May 23 2013 @ 07:39 PM EDT


 Forum Index > Support > Installation Support New Topic Post Reply
 UTF-8
   
Zippo
 08/19/11 05:44PM (Read 948 times)  
+++--
Chatty
confused

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: Idea
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.
-=-=-=-=-=-

 
Profile Email
 Quote
Laugh
 08/19/11 08:25PM  
AAAAA
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

 
Profile Email Website
 Quote
Zippo
 08/20/11 03:15AM  
+++--
Chatty

Status: offline


Registered: 07/08/11
Posts: 53
Thanks....

I searched on "utf_8", that's why I missed it Frown

Ok.. have some work tot do... Wink

Thanks again,

Grtz.
Zippo

 
Profile Email
 Quote
Zippo
 08/20/11 03:33AM  
+++--
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.

 
Profile Email
 Quote
::Ben
 08/20/11 06:44AM  
+++++
Full Member

Status: offline


Registered: 01/14/05
Posts: 1359
You can find a tutorial here.

Ben

We speak french on http://geeklog.fr
 
Profile Email Website
 Quote
Zippo
 08/20/11 07:24AM  
+++--
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.

 
Profile Email
 Quote
Laugh
 08/20/11 09:35AM  
AAAAA
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.

 
Profile Email Website
 Quote
Zippo
 08/20/11 06:36PM  
+++--
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) Evil

 
Profile Email
 Quote
Content generated in: 0.56 seconds
New Topic Post Reply

Normal Topic Normal Topic
Sticky Topic Sticky Topic
Locked Topic Locked Topic
New Post New Post
Sticky Topic W/ New Post Sticky Topic W/ New Post
Locked Topic W/ New Post Locked Topic W/ New Post
View Anonymous Posts 
Able to post 
Filtered HTML Allowed 
Censored Content