리자

utf8 사용시 쉘에서도 한글입력가능하게..

1. 소스컴파일시 옵션 ( euckr, readline 추가해줌)
# ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/var --with-charset=utf8 --with-extra-charsets=euckr --with-readline

# make;make install

 

2. 로긴해서

mysql> set character_set_results=euckr;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_client=euckr;
Query OK, 0 rows affected (0.00 sec)

[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]
|

댓글 2개

이런 것은 호스팅 업체들이 봐 주었으면 좋겠다는 생각이드네요.
저게 안되어 있으면, innodb 쓸때 문제가 생긴다는..
좋은 팁 감사드립니다.
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,188건
+
제목 글쓴이 날짜 조회
10-05-31 조회 2,985
10-04-17 조회 4,754
10-03-23 조회 5,914
10-02-26 조회 3,442
10-02-23 조회 3,390
10-02-11 조회 4,016
10-02-09 조회 3,064
10-01-26 조회 3,518
10-01-23 조회 6,871
10-01-19 조회 3,566
10-01-13 조회 3,767
09-12-06 조회 4,801
09-11-24 조회 4,269
09-11-19 조회 3,129
09-11-11 조회 3,733
09-08-30 조회 3,217
09-08-12 조회 3,225
09-07-21 조회 3,384
09-07-19 조회 3,267
09-07-11 조회 3,192
09-06-15 조회 2,967
09-05-29 조회 3,132
09-05-28 조회 3,573
09-05-05 조회 3,446
09-04-07 조회 3,652
09-02-23 조회 4,442
09-02-17 조회 3,180
09-02-17 조회 2,557
09-02-09 조회 2,667
09-01-23 조회 3,480
09-01-17 조회 4,302
09-01-08 조회 3,248
08-11-07 조회 4,517
08-11-01 조회 4,994
08-10-30 조회 3,587
08-10-16 조회 3,513
08-10-02 조회 2,655
08-09-22 조회 3,983
08-09-22 조회 2,950
08-09-20 조회 5,441
08-09-20 조회 4,515
08-09-20 조회 3,602
08-09-20 조회 2,977
08-09-20 조회 3,172
08-09-20 조회 4,154
08-09-20 조회 3,656
08-09-20 조회 3,243
08-09-18 조회 3,500
08-09-06 조회 3,085
08-09-06 조회 2,830
08-09-05 조회 3,486
08-09-05 조회 5,698
08-09-03 조회 4,498
08-09-03 조회 2,759
08-07-31 조회 3,216
08-07-18 조회 3,817
08-06-19 조회 3,160
08-06-15 조회 3,153
08-06-14 조회 3,612
08-05-23 조회 2,851
08-05-13 조회 2,749
08-04-22 조회 4,431
08-04-22 조회 5,146
08-04-22 조회 6,905
08-04-17 조회 3,042
08-04-17 조회 3,657
08-04-17 조회 3,731
08-04-17 조회 5,989
08-04-17 조회 3,188
08-04-17 조회 3,510
08-04-06 조회 3,575
08-04-05 조회 3,158
08-04-04 조회 7,213
08-04-04 조회 4,503
08-04-04 조회 3,857
08-04-04 조회 4,045
08-04-04 조회 2,923
08-04-04 조회 2,707
08-04-04 조회 2,745
08-04-04 조회 2,958
08-04-04 조회 2,695
08-04-04 조회 2,679
08-04-04 조회 4,186
08-04-03 조회 2,727
08-04-03 조회 3,932
08-04-02 조회 3,140
08-04-02 조회 2,876
08-03-25 조회 3,735
08-03-11 조회 3,495
08-03-11 조회 2,993
08-03-11 조회 2,954
08-03-11 조회 2,755
08-03-11 조회 2,532
08-03-11 조회 2,333
08-03-11 조회 2,401
08-03-07 조회 2,963
08-03-05 조회 2,683
08-02-27 조회 2,940
08-02-21 조회 2,802
08-02-21 조회 3,360