保留对象时,Hibernate编码错误[UTF-8]
问题内容:
在保留模型对象时,我面临UTF-8编码问题。在土耳其的“ ı
”是一个字母。另外,UTF-8编码中还包含其他一些土耳其语字符。虽然我坚持我的模型对象,所有“ ı ”字符被持久化为“ ? ‘到DB。我
在Ubuntu Linux 64位OS上 使用 MySQL 5.5
。另外,我已经将hibernate和c3p0连接编码属性设置为UTF-8。当我调试时,数据来自客户端是真实的。
这是我的配置,如果有人可以帮助我,我会很高兴。
提前致谢。
Spring和Hibernate配置
<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
<property name="dataSource"><ref local="dataSource"/></property>
<property name="packagesToScan" value="com.tk.dms.model" />
<property name="hibernateProperties">
<props>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.use_sql_comments">true</prop>
<prop key="hibernate.format_sql">false</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
<prop key="hibernate.generate_statistics">true</prop>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</prop>
<prop key="hibernate.connection.characterEncoding">UTF-8</prop>
<prop key="hibernate.connection.useUnicode">true</prop>
<!-- c3p0 properties -->
<prop key="hibernate.c3p0.min_size">2</prop>
<prop key="hibernate.c3p0.max_size">50</prop>
<prop key="hibernate.c3p0.maxPoolSize">50</prop>
<prop key="hibernate.c3p0.minPoolSize">2</prop>
<prop key="hibernate.c3p0.initialPoolSize">2</prop>
<prop key="hibernate.c3p0.timeout">300</prop>
<prop key="hibernate.c3p0.max_statements">50</prop>
</props>
</property>
</bean>
问题答案:
尝试在数据源中设置编码
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://127.0.0.1:3306/databaseName?characterEncoding=UTF-8</value>
</property>
<property name="username">
<value>?</value>
</property>
</bean>
您还确定表单输入正确编码吗?您在spring应用程序中使用filter吗?在持久化之前,以调试模式运行应用程序并检查模型对象的字段。
过滤器应放置在您的web.xml文件中:
<filter>
<filter-name>SetCharacterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF8</param-value>
</init-param>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>SetCharacterEncodingFilter</filter-name>
<url-pattern>*</url-pattern>
</filter-mapping>