๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
728x90
๋ฐ˜์‘ํ˜•

ํ•œ๊ธ€์˜ค๋ฅ˜1

[MariaDB] INSERT๋ฌธ ํ•œ๊ธ€ ์˜ค๋ฅ˜(Incorrect string value) ํ•ด๊ฒฐ my.ini ํŒŒ์ผ์— ์•„๋ž˜ ์†์„ฑ์„ ์ง€์ • [mysqld] init_connect="SET collation_connection = utf8_general_ci" init_connect="SET NAMES utf8" collation-server = utf8_general_ci character-set-server = utf8 [client] default-character-set = utf8 [mysql] default-character-set=utf8โ€‹ Mysql> SHOW VARIABLES LIKE "c%" ๋ช…๋ น ์ž…๋ ฅ ํ›„ Value๊ฐ’์— 'latin1'์ด ์žˆ์œผ๋ฉด ์•ˆ๋จ. ๋ชจ๋‘ 'utf8'๋กœ ๋ฐ”๊พผ๋‹ค. ์ฟผ๋ฆฌ์ฐฝ์—์„œ ์†์„ฑ ์„ค์ •์„ ํ•  ์ˆ˜ ์žˆ๋‹ค. (my.ini ์ˆ˜์ •๋งŒ์œผ๋กœ ๋ณ€๊ฒฝ ์•ˆ ๋  ๊ฒฝ์šฐ) Mysql> SET [Var.. 2020. 5. 26.
728x90
๋ฐ˜์‘ํ˜•

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”