Hi Yuji, I have never heard of a character set thats named ucs2
This are the character sets which came with 4.1 alpha: baby-bumble-bee:/usr/share/mysql/charsets # ls . README cp1250.xml cp1257.xml cp866.xml hebrew.xml koi8r.xml latin2.xml macce.xml .. armscii8.xml cp1251.xml cp850.xml dec8.xml hp8.xml koi8u.xml latin5.xml macroman.xml Index.xml ascii.xml cp1256.xml cp852.xml greek.xml keybcs2.xml latin1.xml latin7.xml swe7.xml I guess that this is a misconfguration. I am not sure were you want to go. Did you compile it yourself ? Do you want to create your own character set ? My guess is that you perhaps wanted to use the new UTF-8 charcater set. Is that right ? Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 15:04、Yuji Sato さんは書きました: > Hi Nils, > > I have no ucs2.xml in the "/usr/local/share/mysql/charsets/" . > but I was looking for about ucs2 in the > "/usr/local/share/mysql/charsets/Index.xml" . > > <charset name="ucs2"> > <family>Unicode</family> > <description>UCS-2 Unicode</description> > <collation name="ucs2" id="35" flag="primary"/> > </charset> > > What should I do? > > Japanese:こちらこそ宜しくお願いします。 > > Nils Valentin wrote: > > 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]