mariaDB_인코딩 설정

버전 10.8

 

##쿼리##

 

show variables like "%char%";

SELECT default_character_set_name, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA  WHERE schema_name = "{데이터베이스이름}";

 

##쿼리창 입력##

set character_set_client = utf8;
set character_set_results = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_server = utf8;
alter table tablename default character set utf8;