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 &auml; when the search results are displayed - how can I overcome this problem that all ampersands (still those in entities too) get "escaped"?!
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.
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)