내 그것도 해봤거든요 그런데 --with-charset=euc_kr
이런 내용은 없던데요...
language | /usr/local/share/mysql/korean/
이런 내용은 있더라고요..
>>정희철 님께서 쓰시길<<
:: 쉘 상에서 mysqladmin variables 해보시면 쫙나옵니다
::
:: >>초보자 님께서 쓰시길<<
::
:: :: 내 character set은 한글로 되어있는데요
:: ::
:: :: 저게 freebsd를 쓰고있습니다...
:: ::
:: :: 초보라 제가 뭘 몰라서 그럴수도 있네요..
:: ::
:: :: 허정수님 책보고 열심히 공부중입니다..
:: ::
:: :: 그리고 mysql은 제가 깔아 놓은게 아니라서 그건 모르겠네요
:: ::
:: :: 실행시킬때 언어는 korean으로 주고있습니다..
:: ::
:: :: 혹시 mysql 컴파일시에 --with-charset=euc_kr 로 설정해줬는지
:: ::
:: :: 확인할려면 어떻게 하면 되나요..
:: ::
:: :: 그럼..
:: ::
:: ::
:: :: >>허정수 님께서 쓰시길<<
:: ::
:: :: :: 질문이
:: :: ::
:: :: :: WHERE로 검색을 할 때 '%김', '김%', '%김%' 할 때
:: :: ::
:: :: :: 결과가 이상하다는 것인가요?
:: :: ::
:: :: :: 그럼 character set 문제로군요......
:: :: ::
:: :: :: MySQL 데몬을 띄우실 때
:: :: ::
:: :: :: 윈도 사용자라면,
:: :: ::
:: :: :: --default-character-set=euc_kr
:: :: ::
:: :: :: 이런 옵션을 주어 보세요...
:: :: ::
:: :: :: 리눅스 사용자시라면,
:: :: ::
:: :: :: MySQL을 소스로 컴파일 하여 설치하실 때
:: :: ::
:: :: :: --with-charset=euc_kr
:: :: ::
:: :: :: 옵션을 주어야 합니다.
:: :: ::
:: :: :: 이 질문이 아니면 다시 질문을 해주세요 ^^
:: :: ::
:: :: :: 원하는게 어떤 결과인데, 이러한 결과가 나온다.
:: :: ::
:: :: :: 어떻게 해야 하나.
:: :: ::
:: :: :: 이렇게 말이죠 ^^
:: :: ::
:: :: :: >>초보자 님께서 쓰시길<<
:: :: ::
:: :: :: :: 첨부 파일이 안대더라고요
:: :: :: ::
:: :: :: :: 그래서 이렇게 내용만 떠서 보내드립니다...
:: :: :: ::
:: :: :: :: 그럼 확인해주시고 답주세요..
:: :: :: ::
:: :: :: :: 아래 %김 , 김% , %김% 할때 query 이상하게 나온거입니다.
:: :: :: ::
:: :: :: ::
:: :: :: :: CREATE TABLE diary (
:: :: :: :: num int(7) DEFAULT '0' NOT NULL auto_increment,
:: :: :: :: title varchar(255) DEFAULT '' NOT NULL,
:: :: :: :: content text NOT NULL,
:: :: :: :: year int(4) DEFAULT '0' NOT NULL,
:: :: :: :: month tinyint(4) DEFAULT '0' NOT NULL,
:: :: :: :: day tinyint(4) DEFAULT '0' NOT NULL,
:: :: :: :: weather tinyint(4) DEFAULT '0' NOT NULL,
:: :: :: :: face tinyint(4) DEFAULT '0' NOT NULL,
:: :: :: :: wdate date DEFAULT '0000-00-00' NOT NULL,
:: :: :: :: id_fk varchar(20) DEFAULT '' NOT NULL,
:: :: :: :: temp varchar(50) DEFAULT '' NOT NULL,
:: :: :: :: st tinyint(4) DEFAULT '0' NOT NULL,
:: :: :: :: PRIMARY KEY (num)
:: :: :: :: );
:: :: :: ::
:: :: :: :: #
:: :: :: :: # Dumping data for table 'diary'
:: :: :: :: #
:: :: :: ::
:: :: :: ::
:: :: :: :: #
:: :: :: :: # Table structure for table 'imagess'
:: :: :: :: #
:: :: :: :: CREATE TABLE imagess (
:: :: :: :: f_name varchar(10),
:: :: :: :: l_name varchar(10)
:: :: :: :: );
:: :: :: ::
:: :: :: :: #
:: :: :: :: # Dumping data for table 'imagess'
:: :: :: :: #
:: :: :: ::
:: :: :: ::
:: :: :: :: #
:: :: :: :: # Table structure for table 'testone'
:: :: :: :: #
:: :: :: :: CREATE TABLE testone (
:: :: :: :: user varchar(20) DEFAULT '' NOT NULL,
:: :: :: :: hobby varchar(20),
:: :: :: :: region varchar(20),
:: :: :: :: name varchar(20),
:: :: :: :: PRIMARY KEY (user)
:: :: :: :: );
:: :: :: ::
:: :: :: :: #
:: :: :: :: # Dumping data for table 'testone'
:: :: :: :: #
:: :: :: ::
:: :: :: :: INSERT INTO testone VALUES ('baseball','게임','서울','최우원');
:: :: :: :: INSERT INTO testone VALUES ('sockr','축구','목포','심상민');
:: :: :: :: INSERT INTO testone VALUES ('ttt1234','야구','경기','신현동');
:: :: :: :: INSERT INTO testone VALUES ('swim','수영','경기','정종권');
:: :: :: :: INSERT INTO testone VALUES ('foot','족구','대구','이미정');
:: :: :: :: INSERT INTO testone VALUES ('pingp','탁구','대전','홍영자');
:: :: :: :: INSERT INTO testone VALUES ('music','음악','목포','윤대한');
:: :: :: :: INSERT INTO testone VALUES ('movie','영화','광주','권영주');
:: :: :: :: INSERT INTO testone VALUES ('drink','음주','서울','김영훈');
:: :: :: :: INSERT INTO testone VALUES ('mola','야구','서울','윤현식');
:: :: :: :: INSERT INTO testone VALUES ('toyou','수영','부산','오세홍');
:: :: :: :: INSERT INTO testone VALUES ('test02','게임','경기','홍길동');
:: :: :: :: INSERT INTO testone VALUES ('test03','독서','서울','임꺽정');
:: :: :: :: INSERT INTO testone VALUES ('test04','독서','광주','박찬호');
:: :: :: ::
:: :: :: ::
|