Created attachment 612539 [details] Stack trace Description of problem: Searching for the topics with the string "Note — Partitions" in the topic XML field causes an error, I believe because of the unicode em dash. The error reported is as follows, I'll attach the stack trace: javax.el.ELException: /WEB-INF/templates/TopicSearchListActionButtons.xhtml @9,75 rendered="#{render == null || render}": /CustomSearchTopicList.xhtml @237,84 value="#{not empty groupedTopicTagsList.resultList}": javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query The character is valid in topics (which as I understand it are stored as unicode) and therefore should be valid in search? Additional info:
At an initial guess this is likely to be cause by the wrong collation on the database tables. Atm all the tables have "latin1_swedish_ci" and this appears to be the default value. However they should be using "utf8_general_ci", since all the data stored for topics should be UTF-8. I'll look into this more.
Fixed in build 20121123-1253. Cause: This is partly tied into Bug #869459. The other reason is mentioned above, in the the data wasn't being stored correctly. Consequence: Using certain characters would cause an exception to be thrown. Fix: Change the database/tables/columns to have the right encoding. Also see the fix for the bug mentioned above.