Detailed explanation of the solution to garbled characters when JDBC connects to MySQL to process Chinese

Detailed explanation of the solution to garbled characters when JDBC connects to MySQL to process Chinese

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:
  • Example solution for writing garbled Chinese characters into MySQL in PHP
  • MySQL character set garbled characters and solutions
  • Solution to MySQL garbled code problem under Linux
  • How to solve the problem of Chinese garbled characters when inserting table data into MySQL
  • Summary of handling JDBC connection mysql garbled code exception problem
  • Detailed explanation of the Chinese garbled characters problem in MySQL database
  • Solve the problem of garbled data in MySQL database migration

<<:  VMware Tools installation and configuration graphic tutorial for Ubuntu 16.04 64-bit

>>:  Detailed explanation of React setState data update mechanism

Recommend

HTML image img tag_Powernode Java Academy

summary Project description format <img src=&q...

Import csv file into mysql using navicat

This article shares the specific code for importi...

How to add Tomcat Server configuration to Eclipse

1. Window -> preferences to open the eclipse p...

Detailed explanation of fetch network request encapsulation example

export default ({ url, method = 'GET', da...

Learn MySQL database in one hour (Zhang Guo)

Table of contents 1. Database Overview 1.1 Develo...

JavaScript implements AI tic-tac-toe game through the maximum and minimum algorithm

Without further ado, let’s run the screenshot dir...

A brief discussion on the principle of Vue's two-way event binding v-model

Table of contents explain: Summarize Replenish Un...

Implementation of formatting partitions and mounting in Centos7

Linux often encounters situations such as adding ...

A Brief Analysis of CSS Selector Grouping

Selector Grouping Suppose you want both the h2 el...

Learn about JavaScript closure functions in one article

Table of contents Variable Scope The concept of c...

Steps to build the vite+vue3+element-plus project

Use vite to build a vue3 project You can quickly ...