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)
