Cannot insert non latin symbols in MySQL
Posted
by glebreutov
on Stack Overflow
See other posts from Stack Overflow
or by glebreutov
Published on 2010-05-04T02:17:59Z
Indexed on
2010/05/04
2:38 UTC
Read the original article
Hit count: 331
I'm writing web-app using MySQL version 5.1.45, Tomcat 5.5.28 and Hibernate 3
When I'm trying to save string that contains non-latin characters (for example ??????) error occurs:
1589 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1366, SQLState: HY000
1589 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Incorrect string value: '\xD0\xA3\xD0\xBF\xD1\x8F...' for column 'name' at row 1
Hibernate connection settings
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost/E2012?characterEncoding=UTF8&useUnicode=true</property>
<property name="connection.username">***</property>
<property name="connection.password">***</property>
<property name="hibernate.connection.charSet">UTF8</property>
MySQL config My.cnf
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
Even query set name utf-8 doesn't resolve problem
Thanks for help!
© Stack Overflow or respective owner