1. mysql share 디렉토리의 chasets 디렉토리를 찾아라.
ex) mysql 을 소스 컴파일시 설치한 경로가 /usr/local/mysql 이라면 share 디렉토리는
/usr/local/mysql/share/mysql/ 이 되는것이다... 이곳에 분명 charsets 라는 디렉토리도 존재할것이다.
2. 해당 디렉토리로 이동후 간단하게 파일 복사하나를 해준다.
# cp latin1.xml ?.conf
3. -_-; 끝;; 컴파일이고 머고 필요도 없다 그냥 돌아간다...
출처 : http://www.bbong.net/archive/20070531
Posted by
초성으로 검색 ㄱ,ㄴ,ㄷ,ㄹ,으로 가,나,다 검색
하려고 할때 아래와 같이 하면 된다. 그러나 검색 정렬까정 느린긴 하다
switch ( $szFind )
{
case "ㄱ":
$szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^(ㄱ|ㄲ)' OR ( file_name >= '가' AND file_name < '나' ) order by file_name";
break;
case "ㄴ":
$szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㄴ' OR ( file_name >= '나' AND file_name < '다' ) order by file_name";
break;
case "ㄷ":
$szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^(ㄷ|ㄸ)' OR ( file_name >= '다' AND file_name < '라' ) order by file_name";
break;
case "ㄹ":
$szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㄹ' OR ( file_name >= '라' AND file_name < '마' ) order by file_name";
break;
case "ㅁ":
$szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅁ' OR ( file_name >= '마' AND file_name < '바' ) order by file_name";
break;
case "ㅂ":
$szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅂ' OR ( file_name >= '바' AND file_name < '사' ) order by file_name";
break;
case "ㅅ":
$szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^(ㅅ|ㅆ)' OR ( file_name >= '사' AND file_name < '아' ) order by file_name";
break;
case "ㅇ":
$szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅇ' OR ( file_name >= '아' AND file_name < '자' ) order by file_name";
break;
case "ㅈ":
$szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^(ㅈ|ㅉ)' OR ( file_name >= '자' AND file_name < '차' ) order by file_name";
break;
case "ㅊ":
$szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅊ' OR ( file_name >= '차' AND file_name < '카' ) order by file_name";
break;
case "ㅋ":
$szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅋ' OR ( file_name >= '카' AND file_name < '타' ) order by file_name";
break;
case "ㅌ":
$szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅌ' OR ( file_name >= '타' AND file_name < '파' ) order by file_name";
break;
case "ㅍ":
$szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅍ' OR ( file_name >= '파' AND file_name < '하' ) order by file_name";
break;
case "ㅎ":
$szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅎ' OR ( file_name >= '하') order by file_name";
break;
}
//ㄱ만 ㅎㅎ
//SELECT file_name FROM title_tbl where file_name RLIKE '^(ㄱ|ㄲ)' OR ( file_name >= '가' AND file_name < '나' ) order by file_name
움.
Posted by
