[jboss-user] [JBoss Portal] - Re: unicode settings for mysql 5.0 database

[k3nnymusic]

I found where its broken but I don't know how Can I repair that. Look at the error:


  | 2007-07-26 10:13:23,441 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not insert: [org.jboss.portlet.forums.impl.PostImpl] [insert into jbp_forums_posts (jbp_topic_id, jbp_edit_count, jbp_edit_date, jbp_create_date, jbp_subject, jbp_text, jbp_poster_id) values (?, ?, ?, ?, ?, ?, ?)]
  | java.sql.SQLException: Incorrect string value: '\xC3\xB3\xC4?\xC5?...' for column 'jbp_subject' at row 1
  | 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
  | 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934)
  | 	at 
  | 

In my database I configured charset to latin2 in all forum tables, and in forum I have problem if I put special chars from latin2. Futhermore I added charset to my jdbc configuration


  | <connection-url>jdbc:mysql://localhost:3306/jboss?charSet=iso-8895-2</connection-url>
  | 
in mysql and portal mysql .xml files.

What else should I do?

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

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