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]
