Bug #6337 char ascii flag
Submitted: 30 Oct 2004 15:12 Modified: 13 Oct 2005 9:41
Reporter: [ name withheld ] Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.0.13 OS:Windows (Windows XP Pro)
Assigned to: Michael G. Zinner CPU Architecture:Any

[30 Oct 2004 15:12] [ name withheld ] 
Description:
It looks like MySQL Server 4.0.21 does not recognize the flag ASCII in altering a table column... the MySQLAdministrator tool always returns error when I try to set it and update the table. In case environment is envolved, I use MySQLAdministrator 1.0.13, MyODBC 3.51, MySQL (server) 4.0.21, Windows XP Pro SP1. 

How to repeat:
Just create a new field in a database using MySQLAdministrator, set it to a CHAR type and check the ASCII FLAG. When you press Apply changes, the query will result in an error response.

Suggested fix:
A problem from the server or from the tool? MyAccess for instance does not allow ASCII or UNICODE flags for the CHAR type.
[1 Nov 2004 22:39] MySQL Verification Team 
Hi,

Thank you for the report, but this is not a bug.
ASCII attribute is supported from MySQL 4.1.0
[13 Oct 2005 9:41] Mike Lischke 
There is a new table editor in the works, which will also address this issue.