Creating blog with umlauts in blog title

[marcus]

Hi all,

i am new to s9y however my problem cannot be a user-induced problem by definition.

When creating a blog the usual way (calling /index.php for the first time) and i am asked to enter a blog-title and a blog-description i cannot supply strings with umlauts. I mean i can enter them and finish the installation but the resulting new blog shows bad characters for them. In detail this means:

When opening the blog, the browser automatically selects UTF-8 as character encoding but even overriding it iso-8859-1 does not cure the issue - the bad characters change to differently bad characters. I also tried reinstalling (same /index.php story) with browsers charater encoding setting overridden, but is does not give a positive result either - again only differently bad characters.

Nevertheless in the blog all other items are displayed correctly, for example the 'next page' link is displayed with correct umlauts. Only the blog title and blog description are bad.

Please either fix this problem or explain what i have been doing wrong.

BTW: Using newest full s9y release with lighttpd running under Ubuntu and Firefox 3 under XP SP3 as client. Same setup allowed me to create a WP blog without problems, but i want to switch to s9y...

Best regards,
Marcus

[garvinhicking]

Hi!

Yes, sadly for installation there is a charset issue. Have you tried to re-enter the blog title/description AFTER installation to the proper one? That should work in all cases.

(The issue happens because at installation, s9y does not know which future charset it will have, so I believe it uses UTF-8)

HTH,
Garvin

[marcus]

Thanks for your help. Editing the blog title afterwards worked fine.

@Garvin
might it be an issue with the database default charset, because my MySQL installation defaults to latin1_swedish_ci?

Best regards,
Marcus

[garvinhicking]

Hi!

might it be an issue with the database default charset, because my MySQL installation defaults to latin1_swedish_ci?

Yes, this would exactly be a problem, because s9y does not issue the SQL charset until after installation initialization is complete... this is a conceptual problem that I currently do not know how to solve properly without writing larger parts of the SQL abstraction code and make MySQL specific additions...

Regards
Garvin