Graham Reeds wrote:
Quentin Bennett wrote:
http://dev.mysql.com/doc/refman/4.1/en/alter-table.html
From MySQL 4.1.2 on, if you want to change the table default
character set and 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;
That is the syntax I used. What about prior to 4.1.2?
Perhaps it was not available? See
http://www.dev.mysql.com/doc/refman/4.1/en/charset-table.htm
You may have to dump the data and then reload into a new table with the
correct charset. You may be able to copy it using an INSERT .... SELECT
(not sure though, haven't had to do it)
Regards
--
David Logan
South Australia
when in trouble, or in doubt
run in circles, scream and shout
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]