[pLog-svn] r1514 - in plog/trunk/class/gallery: . daodatagetid3resizers template

无名小虾 sunajia at gmail.com
Wed Mar 16 09:16:20 GMT 2005


Oh also, Mark, I don't know whether you still remember I sent you an
email about one or two weeks ago about the Chinese UTF8 stuff, I
finally found the problem: it's MySQL!!!

The situation is I installed my plog on my existing database, which is
MySQL 4.1.10, and the database's default charactor set is GB2312,
after the installation, I found all the default character set for the
plog system are GB2312 as well, I manually changed them all into UTF8,
but it still not working well, whenever I input some chinese into the
database, the result back is crape...

After googling, I found the solution for this problem: we need to
query a "SET NAMES 'utf8'" before any queries to the database, this
will change the connection layer of database to be UTF8 compatible.
I've done some code last night, you can have a try.

And also, I think for the installation part, we need to do some check
for the database side, afther MySQL 4.1, the character set is a
requirement for any database, if you do not provide a character set
for tables, all the tables would inheritant the database character
setting, which in my case is GB2312, which is what we don't want to
be, so I would suggest in the installation we need to check if the
MySQL is 4.1+ we need to add a "DEFAULT CHARSET=utf8" at the end of
the create table query.


On Wed, 16 Mar 2005 17:01:55 +0800, Mark Wu <markplace at gmail.com> wrote:
> Really? I check it right now ...
> 
> Mark
> 
> -----Original Message-----
> From: plog-svn-bounces at devel.plogworld.net
> [mailto:plog-svn-bounces at devel.plogworld.net] On Behalf Of Allan Sun
> Sent: Wednesday, March 16, 2005 4:55 PM
> To: plog-svn at devel.plogworld.net
> Subject: Re: [pLog-svn] r1514 - in plog/trunk/class/gallery: .
> daodatagetid3resizers template
> 
> But I still got the "splace in folder name" bug last night.
> 
> > From: Mark Wu <markplace at gmail.com>
> > Reply-To: <plog-svn at devel.plogworld.net>
> > Date: Wed, 16 Mar 2005 15:37:04 +0800
> > To: <oscar at renalias.net>, <plog-svn at devel.plogworld.net>
> > Subject: RE: [pLog-svn] r1514 - in plog/trunk/class/gallery: . dao
> > datagetid3resizers template
> >
> > I see, I misunderstand ... Forget it.
> >
> > Mark
> >
> > -----Original Message-----
> > From: plog-svn-bounces at devel.plogworld.net
> > [mailto:plog-svn-bounces at devel.plogworld.net] On Behalf Of Oscar
> > Renalias
> > Sent: Wednesday, March 16, 2005 2:12 PM
> > To: plog-svn at devel.plogworld.net
> > Subject: Re: [pLog-svn] r1514 - in plog/trunk/class/gallery: . dao
> > datagetid3resizers template
> >
> > On Wed, 16 Mar 2005 12:04:06 +0800, Mark Wu <markplace at gmail.com> wrote:
> >> HI Oscar:
> >>
> >> Do you mean you just upgrade the getid3 to new version? I need to
> >> check it ... Because I remember I commit a patch long time ago to
> >> prevent "space in folder name" problem.
> >>
> >> I really need to document it :( sorry
> >
> > no no, I only added documentation strings so that when we generate it
> > automatically it looks nicer :-)
> >
> > I am going to upload the API docs to somewhere in plogworld.net as a
> > reference for those who need it so am I going through each class
> > making sure that it has some description about what it does,
> > parameters, etc, but I am not going to modify any code.
> >
> > Oscar
> > _______________________________________________
> > pLog-svn mailing list
> > pLog-svn at devel.plogworld.net
> > http://devel.plogworld.net/mailman/listinfo/plog-svn
> >
> > _______________________________________________
> > pLog-svn mailing list
> > pLog-svn at devel.plogworld.net
> > http://devel.plogworld.net/mailman/listinfo/plog-svn
> 
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.plogworld.net
> http://devel.plogworld.net/mailman/listinfo/plog-svn
> 
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.plogworld.net
> http://devel.plogworld.net/mailman/listinfo/plog-svn
> 


-- 
With kind regards,
Allan Sun

无名小虾

07900984568
Sunajia at cninuk.com

================================
Chief Editor,
CNINUK Online Magazine

4 Riddell Court
20 Albany Road
London
SE5 0DS

www.cninuk.com
全英华人多维社区
=================================
-------------- next part --------------
A non-text attachment was scrubbed...
Name: model.class.php
Type: application/octet-stream
Size: 4089 bytes
Desc: not available
Url : http://www.plogworld.net/pipermail/plog-svn/attachments/20050316/02380802/model.class.obj


More information about the pLog-svn mailing list