linux和mysql的字符编码问题 [英] Character encoding issue with linux and mysql

问题描述

我正在从Web服务获取包含此子字符串gratuit.AFLĂMAI MULTEDe 的字符串.当我将其保存在本地(windows)数据库中时，工作正常，但是当我尝试将其部署在linux上时保存在服务器上时，出现以下错误:

I am getting this string which contains this substring gratuit.AFLĂ MAI MULTEDe from webservice. when i save this in data base in my local(windows) works fine but when i try to save on server when it is deployed on linux i get following error:

Incorrect string value: '\xC4\x82 MAI...' for column 'description' at row 1

我正在将hibernate 3.3与mysql 5.5(Windows和linux)以及数据库使用默认编码(latin1)一起使用.

I am using hibernate 3.3 with mysql 5.5 (both windows and linux) and database usage default encoding (latin1).

我尝试在JAVA_OPT中设置 -Dfile.encoding = UTF8 ，但是没有用，我认为这是与操作系统相关的问题.

I have tried setting -Dfile.encoding=UTF8 in JAVA_OPT but not worked, i think its this is os related problem.

有什么建议吗?

推荐答案

(通常，如今，我会在UTF-8中进行所有操作.)可以设置编码的点很长.从Web服务中，您可能会获得UTF-8中的XML.由于XML处理严格的编码，因此可以自动正确读取.

(In general nowadays I would do all in UTF-8.) There is a long pipeline of points where encoding can be set. From the web service you get probably XML in UTF-8. That is automatically read correctly, as XML handles the encoding strict.

在数据库级别，存在具有默认和显式编码的数据库，表和字段.此外，应将连接网址的参数设置为正确的编码.

On database level there is the database and table and field with a default and explicit encoding. Furthermore the connection url should be parametrised to the correct encoding.

错误消息显示该重音 A 的UTF-8字节，我想它在Latin1中不可用.对于MySQL，连接字符串可能类似于:

The error message shows the UTF-8 bytes for that accented A and I guess it is not available in Latin1. For MySQL the connection string could look like:

jdbc:mysql://localhost/MYDB?useUnicode=true&characterEncoding=UTF-8

这篇关于linux和mysql的字符编码问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！