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)
• Status: Duplicate
• 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

Description:
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
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql>

[25 Mar 2006 1:00] Gisbert Selke

See also #16990.

[8 Sep 2006 12:28] Mike Lischke

Duplicate to #16990