리자

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,187건
+
제목 글쓴이 날짜 조회
08-06-15 조회 3,213
08-06-15 조회 2,438
08-06-14 조회 2,775
08-06-14 조회 3,679
08-06-14 조회 3,367
08-06-12 조회 2,241
08-06-11 조회 2,288
08-06-11 조회 2,380
08-06-11 조회 7,408
08-06-11 조회 7,140
08-06-08 조회 3,312
08-06-07 조회 2,247
08-06-05 조회 2,375
08-06-05 조회 3,344
08-06-05 조회 2,715
08-06-05 조회 2,368
08-06-05 조회 2,390
08-06-04 조회 2,315
08-06-03 조회 2,307
08-06-03 조회 5,382
08-06-03 조회 3,614
08-06-02 조회 2,907
08-06-02 조회 4,055
08-06-01 조회 2,667
08-05-31 조회 2,367
08-05-31 조회 2,379
08-05-31 조회 2,466
08-05-30 조회 2,336
08-05-29 조회 2,487
08-05-29 조회 3,757
08-05-27 조회 5,586
08-05-26 조회 2,433
08-05-26 조회 5,339
08-05-25 조회 5,430
08-05-24 조회 2,493
08-05-23 조회 3,502
08-05-23 조회 2,919
08-05-23 조회 4,670
08-05-22 조회 2,675
08-05-21 조회 5,014
08-05-21 조회 4,799
08-05-21 조회 3,946
08-05-20 조회 4,548
08-05-20 조회 4,124
08-05-20 조회 3,347
08-05-20 조회 4,625
08-05-20 조회 3,966
08-05-20 조회 4,852
08-05-19 조회 2,399
08-05-16 조회 3,529
08-05-15 조회 2,592
08-05-15 조회 2,416
08-05-15 조회 2,406
08-05-14 조회 2,349
08-05-13 조회 2,808
08-05-13 조회 4,211
08-05-13 조회 4,625
08-05-09 조회 4,395
08-05-08 조회 3,154
08-05-08 조회 5,308
08-05-08 조회 2,656
08-05-07 조회 2,360
08-05-07 조회 2,507
08-05-07 조회 2,312
08-05-01 조회 2,627
08-05-01 조회 2,976
08-04-29 조회 3,821
08-04-28 조회 3,646
08-04-26 조회 2,668
08-04-26 조회 2,418
08-04-26 조회 3,693
08-04-25 조회 4,119
08-04-23 조회 4,554
08-04-22 조회 4,515
08-04-22 조회 3,649
08-04-22 조회 5,222
08-04-22 조회 4,598
08-04-22 조회 6,985
08-04-22 조회 4,036
08-04-21 조회 3,186
08-04-21 조회 3,232
08-04-21 조회 3,169
08-04-21 조회 2,996
08-04-21 조회 4,093
08-04-20 조회 3,266
08-04-20 조회 2,942
08-04-20 조회 3,468
08-04-19 조회 2,377
08-04-18 조회 3,087
08-04-18 조회 4,420
08-04-17 조회 3,659
08-04-17 조회 3,120
08-04-17 조회 3,324
08-04-17 조회 2,611
08-04-17 조회 3,009
08-04-17 조회 2,494
08-04-17 조회 3,045
08-04-17 조회 3,108
08-04-17 조회 2,298
08-04-17 조회 4,583