Tomcat Chinese garbled characters, mysql Chinese garbled characters _ MySQL

Tomcat Chinese garbled characters, mysql Chinese garbled characters Tomcat

Tomcat Chinese garbled get request.

Modify Add URIEncoding = 'utf-8'

Tomcat Chinese garbled post version

In addition, when uploading parameters, HttpURLConnection needs to be transcoded to url encoding.

outStream.writeBytes("&" + URLEncoder.encode(key, "utf-8") + "=" + URLEncoder.encode(value, "utf-8"));

Mysql Chinese garbled characters

Modify my. cnf and add it under [mysqld]

character-set-server = utf8

When creating a database, the encoding format is UTF-8.

CREATE DATABASE dbname DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Or modify the encoding format of an existing database or table to UTF-8.

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;