Folks --
I'm using
Client version: mysql Ver 14.6 Distrib 4.1.5-gamma, for pc-linux (i686)
Server version: 4.1.5-gamma-standard-log
They both happen to both be on the same system, which is RHEL AS 3.
All defaults are now UTF8:
Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8
I'm trying to convert a table (from a database dumped from a 4.0.x server) to UTF8 on this other (4.1.5) server.
Following the instructions on http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html,
"From MySQL 4.1.2 on, if you want to change all character columns (|CHAR|, |VARCHAR|, |TEXT|) to a new character set, use a statement like this:
ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;
This is useful, for example, after upgrading from MySQL 4.0.x to 4.1.x. See section 11.10 Upgrading Character Sets from MySQL 4.0 <http://dev.mysql.com/doc/mysql/en/Charset-upgrading.html>."
I ran the following:
ALTER TABLE EJOURNAL CONVERT TO CHARACTER SET utf8;
ALTER TABLE EJOURNAL DEFAULT CHARACTER SET utf8;
ALTER DATABASE ERESDB DEFAULT CHARACTER SET utf8;
This was successful on the varchar(255) field, which went from:
Acta cir?rgica brasileira to Acta cirúrgica brasileira
Unfortunately, it was not successful on the *text* field, which has remained:
| Acta cir?rgica brasileira| |
Again, the quoted documentation above *explicitly* says that running the ALTER TABLE command with CONVERT TO CHARACTER SET option will change *TEXT* columns. That has not been my experience.
Anyone tell me what I'm doing wrong here?
TIA, Andy
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
