Re: Unicode(ucs2) setup question

Yuji Sato Tue, 10 Jun 2003 23:05:55 -0700

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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unicode(ucs2) setup question

Reply via email to