Hi Yuji Error 2 means the file doesnt exist. (here: '/usr/local/share/mysql/charsets/ucs2.xml').
Please make sure the file is in the foldr specified and not misspelled. Best regards Nils Valentin Tokyo/Japan Japanese: 宜しくお願いします 2003年 6月 11日 水曜日 14:44、Yuji Sato さんは書きました: > I'd like to use ucs2 character set for MySQL. > > My enviroment is shown below: > OS FreeBSD 4.8 > DB MySQL4.1.0-alpha > > A) > configure option: > --with-charset=ucs2 \ > --with-extra-chasets=all \ > define to /etc/my.cnf by ucs2. > [mysqld] > default-character-set=ucs2 > > Then, It was does not work. > > # ./mysql-server.sh start > # tail /var/db/mysql/MyDB.err > 030610 21:24:08 mysqld started > /usr/local/libexec/mysqld: File > '/usr/local/share/mysql/charsets/ucs2.xml' not found (Errcode: 2) > /usr/local/libexec/mysqld: Character set 'ucs2' is not a compiled > character set and is not specified in the > '/usr/local/share/mysql/charsets/Index.xml' file > 030610 21:24:08 Aborting > 030610 21:24:08 /usr/local/libexec/mysqld: Shutdown Complete > 030610 21:24:08 mysqld ended > > B) > configure option: > --with-extra-chasets=all \ > Of course,It was working. > Then, I created a table u1,and modify to character set by manual operation. > mysql>ALTER TABLE u1 MODIFY b CHAR(20) CHARACTER SET ucs2; > ERROR 1115: Unknown character set: 'ucs2' > > Regards, > > Yujis -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
