unable to handle UNICODE page names

[johnnythehun]

I am using Portal 2.7.0. RC1 with MySql 5.X. The jbp_object_node table collation is utf8_hungarian_ci

I was able to create pages with Unicode chars, for example with the character: ő

But JBoss Portal admin cannot rename, nor delete the page with the above mentioned char. It throws the exception:

org.jboss.portal.core.model.portal.NoSuchPortalObjectException: Child őűáéÃó of /MyPortal/harmadik does not exist

My users will definitly create pages with hungarian unicode chars, so I need to resolve this issue.

Could you help me?

Other:
I checked, and the default theme, admin page layout has no
charset set (ex: charset=iso-8859-2) in the meta http-equiv="Content-Type" tag.
Do I have to modify the source jsp to set the charset?

Thanks in advance,

John

[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>