1 Reply Latest reply on Nov 20, 2008 11:07 AM by John Gerevich

    unable to handle UNICODE page names

    John Gerevich Newbie

      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

        • 1. Re: unable to handle UNICODE page names
          John Gerevich Newbie

          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>