[jboss-user] [JBoss Portal] - Re: unable to handle UNICODE page names

[JohnnyTheHun]

The problem was with the mysql datasource config.

I added the following 3 lines and that helped:


  | 
  |     <connection-property name="useUnicode">true</connection-property>
  |     <connection-property name="characterEncoding">utf8</connection-property>
  |     <connection-property name="useLocalSessionState">true</connection-property> 
  |     
  | 
  |   | 
  |   | So the whole datasource looks like:
  |   | 
  |   | 
  |   |   | <datasources>
  |   |   |   <local-tx-datasource>
  |   |   |     <jndi-name>PortalDS</jndi-name>
  |   |   |     <connection-url>jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false&amp;jdbcCompliantTruncation=false</connection-url>
  |   |   |     <connection-property name="useUnicode">true</connection-property>
  |   |   |     <connection-property name="characterEncoding">utf8</connection-property>
  |   |   |     <connection-property name="useLocalSessionState">true</connection-property> 
  |   |   |     <driver-class>com.mysql.jdbc.Driver</driver-class>
  |   |   |     <user-name>xxx</user-name>
  |   |   |     <password>xxx</password>
  |   |   |   </local-tx-datasource>
  |   |   | </datasources>
  |   |   | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4190955#4190955

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4190955