리자

MySQL 한글 정렬 Tip

· 2007-06-20 (수) 12:33:17 · 4035
한글정렬이 잘 안될때는
 
시작 매개변수에 --default-character-set=euc_kr 을 추가
 
또는
 
select * from table order by binary(field)
 
binary()를 추가 한다.
 
또는
 
my.ini 파일에
 
[mysqld]
default-character-set=euc_kr
 
추가한다.
 
 
[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
08-06-15 조회 3,197
08-06-15 조회 2,426
08-06-14 조회 2,760
08-06-14 조회 3,665
08-06-14 조회 3,353
08-06-12 조회 2,232
08-06-11 조회 2,278
08-06-11 조회 2,369
08-06-11 조회 7,397
08-06-11 조회 7,129
08-06-08 조회 3,304
08-06-07 조회 2,235
08-06-05 조회 2,370
08-06-05 조회 3,338
08-06-05 조회 2,703
08-06-05 조회 2,360
08-06-05 조회 2,380
08-06-04 조회 2,298
08-06-03 조회 2,297
08-06-03 조회 5,372
08-06-03 조회 3,606
08-06-02 조회 2,901
08-06-02 조회 4,040
08-06-01 조회 2,655
08-05-31 조회 2,359
08-05-31 조회 2,369
08-05-31 조회 2,460
08-05-30 조회 2,325
08-05-29 조회 2,477
08-05-29 조회 3,745
08-05-27 조회 5,580
08-05-26 조회 2,421
08-05-26 조회 5,328
08-05-25 조회 5,418
08-05-24 조회 2,482
08-05-23 조회 3,492
08-05-23 조회 2,904
08-05-23 조회 4,660
08-05-22 조회 2,661
08-05-21 조회 5,006
08-05-21 조회 4,785
08-05-21 조회 3,929
08-05-20 조회 4,527
08-05-20 조회 4,117
08-05-20 조회 3,341
08-05-20 조회 4,609
08-05-20 조회 3,954
08-05-20 조회 4,842
08-05-19 조회 2,389
08-05-16 조회 3,516
08-05-15 조회 2,578
08-05-15 조회 2,407
08-05-15 조회 2,397
08-05-14 조회 2,340
08-05-13 조회 2,795
08-05-13 조회 4,197
08-05-13 조회 4,616
08-05-09 조회 4,384
08-05-08 조회 3,146
08-05-08 조회 5,292
08-05-08 조회 2,649
08-05-07 조회 2,343
08-05-07 조회 2,495
08-05-07 조회 2,305
08-05-01 조회 2,619
08-05-01 조회 2,969
08-04-29 조회 3,811
08-04-28 조회 3,634
08-04-26 조회 2,660
08-04-26 조회 2,409
08-04-26 조회 3,684
08-04-25 조회 4,104
08-04-23 조회 4,536
08-04-22 조회 4,497
08-04-22 조회 3,641
08-04-22 조회 5,205
08-04-22 조회 4,585
08-04-22 조회 6,966
08-04-22 조회 4,026
08-04-21 조회 3,175
08-04-21 조회 3,226
08-04-21 조회 3,155
08-04-21 조회 2,982
08-04-21 조회 4,087
08-04-20 조회 3,251
08-04-20 조회 2,933
08-04-20 조회 3,461
08-04-19 조회 2,369
08-04-18 조회 3,079
08-04-18 조회 4,414
08-04-17 조회 3,649
08-04-17 조회 3,094
08-04-17 조회 3,312
08-04-17 조회 2,603
08-04-17 조회 2,994
08-04-17 조회 2,478
08-04-17 조회 3,031
08-04-17 조회 3,094
08-04-17 조회 2,286
08-04-17 조회 4,575