티스토리 뷰

Database

SET NAMES, SET CHARACTER SET

초보의 CHOMAN 2019. 9. 19. 15:05

SET NAMES는 클라이언트가 서버에 SQL명령문을 보낼 때 사용하는 문자 셋을 가리킨다.

SET NAMES

SET character_set_client
SET character_set_results
SET character_set_connection

SET CHARACTER SET

SET character_set_client
SET character_set_results
SET collation_connection = @@collation_database;

'Database' 카테고리의 다른 글

mariadb (Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help.In current row format, BLOB prefix of 768 bytes is stored inline)  (0) 2020.04.23
mysqldump (archive engine)  (0) 2020.03.30
SET NAMES, SET CHARACTER SET  (0) 2019.09.19
Character set Collation 차이  (0) 2019.09.18
log_bin_trust_function_creators (This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)  (0) 2019.07.17
mysql index hint  (0) 2019.06.27
공유하기 링크
댓글
댓글쓰기 폼
1 2 3 4 5 6 7 8 9 ··· 31
공지사항