리자

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건
+
제목 글쓴이 날짜 조회
07-07-16 조회 3,122
07-07-06 조회 3,008
07-07-06 조회 3,438
07-06-23 조회 3,268
07-06-16 조회 2,776
07-05-20 조회 4,282
07-05-09 조회 3,458
07-05-09 조회 6,100
07-05-04 조회 2,692
07-04-30 조회 9,830
07-04-27 조회 4,332
07-04-26 조회 3,445
07-04-25 조회 5,289
07-04-18 조회 7,787
07-04-13 조회 3,124
07-04-12 조회 6,634
07-04-12 조회 5,042
07-04-12 조회 3,351
07-04-11 조회 5,716
07-04-05 조회 6,357
07-03-24 조회 4,417
07-03-20 조회 3,742
07-03-18 조회 3,990
07-03-18 조회 4,737
07-03-17 조회 4,236
07-03-16 조회 4,130
07-03-15 조회 5,294
07-03-13 조회 5,402
07-03-13 조회 3,587
07-03-08 조회 4,496
07-03-08 조회 3,982
07-03-08 조회 3,292
07-03-08 조회 4,185
07-03-05 조회 4,434
07-03-04 조회 2,909
07-03-01 조회 5,943
07-02-28 조회 3,231
07-02-27 조회 4,406
07-02-26 조회 3,328
07-02-26 조회 3,033
07-02-23 조회 3,668
07-02-23 조회 3,634
07-02-22 조회 4,017
07-02-22 조회 3,826
07-02-19 조회 3,852
07-02-17 조회 4,868
07-02-14 조회 8,168
07-02-12 조회 3,941
07-02-10 조회 3,561
07-02-02 조회 3,810
07-01-31 조회 3,483
07-01-29 조회 3,342
07-01-25 조회 5,120
07-01-21 조회 3,264
07-01-19 조회 3,049
06-12-15 조회 4,059
06-12-15 조회 4,467
06-12-15 조회 2,953
06-12-15 조회 4,503
06-12-15 조회 3,391
06-12-15 조회 4,099
06-12-15 조회 3,043
06-12-15 조회 2,771
06-12-15 조회 4,634
06-12-15 조회 3,177
06-12-15 조회 3,283
06-12-07 조회 4,729
06-12-07 조회 4,016
06-12-04 조회 4,661
06-11-27 조회 3,708
06-11-21 조회 4,019
06-11-15 조회 3,447
06-11-04 조회 3,338
06-10-29 조회 3,997
06-10-13 조회 3,853
06-10-13 조회 4,222
06-10-13 조회 4,177
06-10-12 조회 5,369
06-10-12 조회 4,282
06-10-04 조회 3,783
06-10-02 조회 4,562
06-09-29 조회 3,051
06-09-26 조회 3,394
06-09-26 조회 3,652
06-09-26 조회 3,298
06-09-26 조회 3,445
06-09-26 조회 4,352
06-09-25 조회 4,656
06-09-22 조회 4,996
06-09-22 조회 3,562
06-09-21 조회 4,336
06-09-21 조회 4,340
06-09-21 조회 3,548
06-09-21 조회 5,196
06-09-21 조회 3,726
06-09-21 조회 3,457
06-09-20 조회 3,033
06-09-15 조회 3,156
06-09-13 조회 3,474
06-09-11 조회 3,284