Bug #14748 Changing the collation of a column seems to have no effect
Submitted: 8 Nov 2005 14:51 Modified: 8 Sep 2006 12:28
Reporter: Gisbert Selke (Basic Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.17 OS:Windows (Win XP)
Assigned to: Mike Lischke CPU Architecture:Any

[8 Nov 2005 14:51] Gisbert Selke
In "edit table" I change the collation for a (var)char column to latin1_german2_ci. The immediate result indicates that this has been accepted. I then display details for another column (still OK). I then switch back to the column I changed a few seconds ago. I expect the collation to be latin1_german2_ci. However, the collation is now again listed as latin1_swedish_ci instead of ...german...

How to repeat:
In "edit table" mode, pick any varchar column, show tab "column
details", change "column collate" drop-down box from default to, say,
latin1_german2_ci. Apply and execute. Drop down box now shows your
choice of collation, seems OK. But now switch to a different column and
then back to the one you just changed, then the "column collate"
drop-down box will show "latin1_swedish_ci" (not german).
[8 Nov 2005 23:46] MySQL Verification Team
It does the alter table, however not displays the change

mysql> show create table tb2\G
*************************** 1. row ***************************
       Table: tb2
Create Table: CREATE TABLE `tb2` (
  `col1` varchar(23) default NULL,
  `col2` varchar(23) character set latin1 collate latin1_german2_ci default NULL
1 row in set (0.00 sec)

[25 Mar 2006 1:00] Gisbert Selke
See also #16990.
[8 Sep 2006 12:28] Mike Lischke
Duplicate to #16990