Maria DB 10.4.12 - Charset, Collation latin1에서 utf8mb4로 변경하기

설정파일로 설정해놓을 예정

 

연결해서 쿼리 수행시키면, 어차피 재시작할때 설정 다 다사라진다.

 

[test@db2 /]$ cd /etc/my.cnf.d
[test@db2 my.cnf.d]$ ls
enable_encryption.preset  mysql-clients.cnf  server.cnf

 

1. mysql-clients.cnf

[test@db2 my.cnf.d]$ sudo vi mysql-clients.cnf

#
# These groups are read by MariaDB server.
#
#
#
#
#
# These groups are read by MariaDB command-line tools
# Use it for options that affect only one utility
#

[mysql]
default-character-set=utf8mb4

[mysql_upgrade]

[mysqladmin]

[mysqlbinlog]

[mysqlcheck]

[mysqldump]
default-character-set=utf8mb4

[mysqlimport]

[mysqlshow]

[mysqlslap]

[client]
default-character-set=utf8mb4
~
~
~
~
~
~

 

 

2. server.cnf

[test@db2 my.cnf.d]$ sudo vi server.cnf

[mysqld]
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
character-set-server = utf8mb4

init_connect='SET collation_connection = utf8mb4_unicode_ci'

 

설정하고 재시작!

[user01@db2 my.cnf.d]$ systemctl restart mariadb.service

 

JPA 다시 실행해도 latin이다?

그럴떈, 테이블을 상위의 데이터베이스의 charset을 확인해보세요

저는 그게 latin이여서 바꿔주니까 

Hibernate: create table user (id bigint not null auto_increment, created_by varchar(255), created_date datetime(6), email varchar(255), login_id varchar(255), password varchar(255), phone varchar(255), updated_by varchar(255), updated_date datetime(6), userName varchar(255), school_id bigint, primary key (id)) engine=InnoDB

뚝딱~

 

너무 답답했는데 해결완료~~