乱码问题截图:
解决方案
一、application.yml
url参数的设置
spring:
jpa:
hibernate:
ddl-auto: update
show-sql: true
datasource:
# docker run -d --name mysql-sharding-jdbc -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -v /opt/dadudu/data/mysql-sharding-jdbc:/var/lib/mysql -v /opt/dadudu/etc/mysql-sharding-jdbc:/etc/mysql mysql:5.7
# docker exec -it mysql-sharding-jdbc bash
# create database ds_2 default charset utf8;
url: jdbc:mysql://192.168.10.30:3306/ds_2?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
username: root
password: 123456
driver-class-name: com.mysql.cj.jdbc.Driver
二、vi /etc/my.cnf
设置字符集为UTF-8
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
三、验证
mysql> select * from ds_2.customer;
+----+-----+------------+-----------+
| id | age | first_name | last_name |
+----+-----+------------+-----------+
| 1 | 0 | 张 | 三 |
| 2 | 0 | 张 | 三 |
+----+-----+------------+-----------+
3 rows in set (0.00 sec)