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; -----Original Message----- From: news [mailto:[EMAIL PROTECTED] Behalf Of Graham Reeds Sent: Monday, 19 June 2006 8:53 a.m. To: mysql@lists.mysql.com Subject: Re: Alter table command don't work Graham Reeds wrote: > Using the text mode mysql client program I tried to alter a table - but > received a syntax error. Why? This is using MySQL 4.0.25 btw. > > mysql> alter table blog convert to character set utf8; > ERROR 1064: You have an error in your SQL syntax. Check the manual that > corresponds to your MySQL server version for the right syntax to use > near 'convert to character set utf8' at line 1 > > G > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]