[pLog-svn] German charset?

BalearWeb balearweb at balearweb.com
Tue Aug 15 14:42:38 GMT 2006


What version of MySQL are you using? Have you checked how
are comments stored in the data base? What charset do they use?
I had some similar problems when backing up and importing a LT db
from 4.1 mysql to a 4.0 mysql. I had to add 
--default-character-set=latin1 to
my mysqldump command if not the 4.1 mysql would export it as UTF-8 by 
default.
I discover that by opening the mysql dump in the SciTE text editor and 
verifying what
charset it was using.

On the other hand, there is something wrong in your HTML, an are extra }
in the link that surrounds the comment author, like here:
<a href="http://jon.limedaley.com/"}>jondaley</a>
I don't think that has any effect on the charset, but at least it needs 
to be
checked.

Elena

Jon Daley wrote:

 >     Using Firefox's "Page Info", it reports ISO-8859-1 for both pages.
 >
 > On Tue, 15 Aug 2006, Oscar Renalias wrote:
 >
 >> I tried posting a comment in the second link and it did not work. I
 >> used umlauts, all sorts of accents and even silly spanish letters such
 >> as 'ñ'. These characters are all part of the iso-8859-1 character set,
 >> so I don't see why they wouldn't work.
 >>
 >> I also checked that the page has the same locale, and it does. Unless
 >> your server is configured to serve pages in some other character
 >> set...
 >>
 >> On 8/15/06, Jon Daley <plogworld at jon.limedaley.com> wrote:
 >>
 >>> Two blogs, on the same server, using a different install of 
LifeType, but
 >>> both the latest svn.
 >>> Both database created with latin1.
 >>>
 >>> 
http://jon.limedaley.com/plog/archives/2006/08/15/My-test-Just-a-Test-for-Umlauts-.
 >>> http://matthias.blog.ch/index.php?op=ViewArticle&articleId=18&blogId=15
 >>>
 >>> Alex: what did you mean when you said "every second comment"?


More information about the pLog-svn mailing list