Bug #9326 EDIT TABLE - Bad syntax for editing values.
Submitted: 22 Mar 2005 5:34 Modified: 28 Apr 2005 4:34
Reporter: Deek Starr Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.5 OS:Microsoft Windows (XP-PRO)
Assigned to: CPU Architecture:Any

[22 Mar 2005 5:34] Deek Starr
Description:

While looking trough the 'Edit Table' proporty tabs, i noticed an language option. I clicked it to view the options however didn't change the option. However now every time I 'Apply Changes' it adds the 'SET latin1 COLLATE latin1_swedish_ci' remark. 

A: How can i remove this? ( Setting langage to default does not remove this. )
B: The new syntax creats an error (See Example1 below).

Example1:
Current

ALTER TABLE `ict-store`.`employees` MODIFY COLUMN `Store_ID` INTEGER UNSIGNED CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

Correct

ALTER TABLE `ict-store`.`employees` MODIFY COLUMN `Store_ID` INTEGER UNSIGNED NOT NULL;

How to repeat:
Clicked Schema.
Clicked Edit Table.
Clicked 'Table Options' Tab.
Clicked 'Latin1'.
Clicked Apply.

Now i can't get it back to normal?
[22 Mar 2005 5:35] Deek Starr
While looking trough the 'Edit Table' property tabs, i noticed an language
option. I clicked it to view the options however didn't change the option.
However now every time I 'Apply Changes' it adds the 'SET latin1 COLLATE
latin1_swedish_ci' remark. 

A: How can I remove this? ( Setting language to default does not remove this. )
B: The new syntax creates an error (See Example1 below).

Example1:
Current

ALTER TABLE `ict-store`.`employees` MODIFY COLUMN `Store_ID` INTEGER UNSIGNED
CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

Correct

ALTER TABLE `ict-store`.`employees` MODIFY COLUMN `Store_ID` INTEGER UNSIGNED
NOT NULL;

How to repeat:
Clicked Schema.
Clicked Edit Table.
Clicked 'Table Options' Tab.
Clicked 'Latin1'.
Clicked Apply.

Now I can't get it back to normal?
[22 Mar 2005 11:18] MySQL Verification Team
I wasn't able to repeat with version 1.1.6. What version are
you using ?
[28 Mar 2005 4:34] Deek Starr
I'm using V1.1.5 for windows and MySQL 5.0.0-alpha.

Hope this helps.
[28 Apr 2005 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".