[pLog-svn] German charset?

Jon Daley plogworld at jon.limedaley.com
Tue Aug 15 18:55:22 GMT 2006


 	I fixed the extra character, but that didn't fix anything.  The 
database settings are correct - identical to my blog's database, which is 
on the same machine.

On Tue, 15 Aug 2006, BalearWeb wrote:

> 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"?
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn
>

-- 
Jon Daley
http://jon.limedaley.com/

What does it mean to mean that the mean was meaningful?
-- Dr. Marcel Just


More information about the pLog-svn mailing list