Bug #10173 cannot change tables character set to default its sql is wrong..
Submitted: 26 Apr 2005 12:36 Modified: 24 May 2005 14:43
Reporter: Tahir YILMAZ Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.0.19 - 1.0.20 OS:Windows (winxp)
Assigned to: Michael G. Zinner CPU Architecture:Any

[26 Apr 2005 12:36] Tahir YILMAZ 
Description:
when you want to change the charset of a table to 'default' it gives an error because of wrong sql statement

How to repeat:
it is repeating when you want such an action that i write above..

Suggested fix:
ALTER TABLE `xxx`.`xxxxxxx` OLLATE Default;

change this staments OLLATE to COLLATE i thinks its very easy
[26 Apr 2005 13:46] MySQL Verification Team 
Thank you for the bug report.
[24 May 2005 14:43] Michael G. Zinner 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html