Detailed explanation of the solution to garbled characters when JDBC connects to MySQL to process Chinese Recently, the integrated project needs to connect to an older version of MySQL server. Using Navicat to check, it is found that this MySQL server does not seem to have a default encoding set, and from some PHP files that operate this MySQL, it should be using the gb2312 encoding. However, when using JDBC operations directly, the Chinese characters read from the database are all garbled. At first, I tried to force encoding conversion using methods like entity.setDepartName(new String(rs.getString("hg").getBytes("gbk"), "utf-8"));, but it failed because no matter which method was used, the converted characters were always garbled, but the way they were garbled was different each time. Quite depressed. Moreover, since this project uses other products, it is not possible to add additional things like filters, so this problem is not easy to deal with. There was no problem using navicat to connect and query, so I tried to export a table to sql to see if there was any encoding setting in the DDL. The result disappointed me because the encoding was not written at all. So, I changed the extension of the exported sql file to html, opened it with IE, and found that there was no garbled code. I checked the encoding format and found that it was "gb2312". However, using java to force transcoding was of no avail. What should I do? Moreover, this project has been running for many years, and there is a lack of post-maintenance. The my.ini file cannot be viewed and modified. Suddenly I remembered that I can add parameters when connecting to MySQL, and some parameters specify encoding. Can this solve the problem? So modify the connection string (the original value is: url="jdbc:mysql://192.168.18.254:3306/web_oa) to: url="jdbc:mysql://192.168.18.254:3306/web_oa?useUnicode=true&characterEncoding=gbk" Restart the application and check, OK! Chinese is normal. Problem solved. This method actually specifies the gbk encoding format when connecting, thereby avoiding the client and server using their own default encoding formats to interact. As long as the configuration is appropriate, there will be no garbled code problem. If you have any questions, please leave a message or come to the community to discuss. Thank you for reading and I hope it can help you. Thank you for your support of this site! You may also be interested in:
|
<<: VMware Tools installation and configuration graphic tutorial for Ubuntu 16.04 64-bit
>>: Detailed explanation of React setState data update mechanism
1. Download MySQL 1.1 Download address https://do...
Table of contents Why use setState Usage of setSt...
Table of contents 01 sql_slave_skip_counter param...
This article summarizes the common commands for L...
Copy code The code is as follows: <!--[if IE]&...
Table of contents Docker images What is a mirror?...
ant-design-vue customizes the use of Ali iconfont...
After solving the form auto-fill problem discussed...
In the many projects I have worked on, there is b...
Table of contents nextTick v-model syntax sugar ....
Flash file formats: .FLV and .SWF There are two ex...
introduce This chapter mainly introduces the proc...
Table of contents MAH 1. Introduction to MAH Arch...
Operating system: Window10 MySQL version: 8.0.13-...
Today is still a case of Watch app design. I love...