#conv -c -f euc-kr -t utf-8 test.txt > test-utf8.txt
위로그 > 서버관리 > linux > 리눅스에서 euc-kr 파일을 utf-8 파일로 변환 명령어

seen from United States
seen from Yemen
seen from United States
seen from Türkiye
seen from United States
seen from United States

seen from Türkiye

seen from Türkiye
seen from Germany
seen from Germany

seen from United Kingdom

seen from United States
seen from Türkiye
seen from China
seen from United States

seen from United Kingdom

seen from United States
seen from Ukraine

seen from United States
seen from United Kingdom
#conv -c -f euc-kr -t utf-8 test.txt > test-utf8.txt
위로그 > 서버관리 > linux > 리눅스에서 euc-kr 파일을 utf-8 파일로 변환 명령어
mysql CharacterSet 변경
mysql> \s
-------------------------------------
Server characterset: euckr
Db characterset: euckr
Client characterset: euckr
Conn. characterset: euckr
-------------------------------------
mysql> SET character_set_client = utf-8;
mysql> SET character_set_results = utf-8;
mysql> SET character_set_connection = utf-8;
mysql> ALTER DATABASE myDBname DEFAULT CHARACTER SET utf-8;
mysql> commit;