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
Copy code The code is as follows: <!--doctype ...
summary Project description format <img src=&q...
This article shares the specific code for importi...
1. Window -> preferences to open the eclipse p...
export default ({ url, method = 'GET', da...
Table of contents 1. Database Overview 1.1 Develo...
transform and translate Transform refers to trans...
Without further ado, let’s run the screenshot dir...
This time I will talk about the skills of develop...
Table of contents explain: Summarize Replenish Un...
Linux often encounters situations such as adding ...
What is a descending index? You may be familiar w...
Selector Grouping Suppose you want both the h2 el...
Table of contents Variable Scope The concept of c...
Use vite to build a vue3 project You can quickly ...