Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Archive /

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Site Search - German Site - Problem with Umlaut


Go to End
Reply


10 Posts   4822 Views

Avatar
KingBerT

Community Member, 11 Posts

16 May 2008 at 8:38pm

Hello,
I'm building a German site - in German we have "Umlaute" (special signs) such as "ä ö ü Ä Ö Ü ß".

I want to integrate a Site Search. I followed the intstructions on the Tutorial and implemented the search.

Now I have the problem, that the Umlaut "ä", written as entity "ä" in the content gets re-escaped to ä when the search results are displayed - how can I overcome this problem that all ampersands (still those in entities too) get "escaped"?!

Can anyone please help me?!

Avatar
ericson

Community Member, 2 Posts

17 May 2008 at 9:07pm

same problem, also by a sent newsletter - thanks for help

Avatar
Ingo

Forum Moderator, 801 Posts

19 May 2008 at 10:18pm

so you've followed our search tutorial? http://doc.silverstripe.com/doku.php?id=tutorial:4-site-search

it outputs the content summary as $Content.LimitWordCountXML, which triggers Convert::raw2xml(). so far so good, no double htmlentities encoding. can you make sure the content is stored without being escaped into htmlentities?

as for the newsletter: we need more info, the source of the sent mails is helpful. i suspect you're sending unicode characters in a iso8859-1 (latin1) encoded mail.

Avatar
KingBerT

Community Member, 11 Posts

5 June 2008 at 7:43am

Oke,
if I use

$Content.LimitWordCount

instead of

$Content.LimitWordCountXML

I get the correct Umlaute.

But in the database Content is stored escaped! Is this right?

...searches for words with Umlaute fail. How can I get this work?

Avatar
Ingo

Forum Moderator, 801 Posts

5 June 2008 at 9:47am

hm database content is stored in utf8 (so don't be fooled by phpmyadmin giving you garbled output, its html encoding is mostly set to latin1).

can you try to get the sql-query thats generated (in SearchForm.php), append a COLLATE utf8 statement (see http://dev.mysql.com/doc/refman/5.1/en/charset-collate.html), and execute it manually? if it still doesn't work, can you post the query thats failing here? (-> http://pastie.caboo.se)

Avatar
KingBerT

Community Member, 11 Posts

5 June 2008 at 5:28pm

No no, content is stored escaped (with html_entities I think)!

Example:

ist immer ein Kompromiß aus Funktionalität, Wirtschaftlichkeit und Sicherheit.

I started to work with 2.2.0 and updated last week to version 2.2.2!

What can I do now?

Avatar
SunPower

Community Member, 6 Posts

1 July 2008 at 3:07pm

Same problem, also by a searches for words with Umlaute fail.

How can I get this work?

Version 2.2.2

Help please!

Avatar
UN

Community Member, 1 Post

20 July 2008 at 5:44am

I've got the same problem, so what can I do?

Go to Top