SilverStripe Forum

• Overview
• User help
• Tutorials
• Documentation
• Forums
• IRC
• Mailing Lists
• Showcase
• Bugs
• How to Contribute
• Donate
• Roadmap
• Search (new!)

• KingBerT
  
  Community Member
  10 posts
  

  Site Search - German Site - Problem with Umlaut

  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?!

• ericson
  
  Community Member
  2 posts
  

  Re: Site Search - German Site - Problem with Umlaut

  17 May 2008 at 9:07pm

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

• Ingo
  
  Core Development Team
  313 posts
  

  Re: Site Search - German Site - Problem with Umlaut

  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.

• KingBerT
  
  Community Member
  10 posts
  

  Re: Site Search - German Site - Problem with Umlaut

  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?

• Ingo
  
  Core Development Team
  313 posts
  

  Re: Site Search - German Site - Problem with Umlaut

  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)

• KingBerT
  
  Community Member
  10 posts
  

  Re: Site Search - German Site - Problem with Umlaut

  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?

• SunPower
  
  Community Member
  3 posts
  

  Re: Site Search - German Site - Problem with Umlaut

  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!

• UN
  
  Community Member
  1 post
  

  Re: Site Search - German Site - Problem with Umlaut

  20 July 2008 at 5:44am

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