Bug #20157 collations lost, collations not selectable

• Submitted: 30 May 2006 23:05
• Modified: 31 May 2006 14:08
• Reporter: Dominic Clifton
• Status: Won't fix
• Category: MySQL Workbench Preview
• Severity: S1 (Critical)
• Version: 1.06
• OS: Windows (Win32)
• CPU Architecture: Any

[30 May 2006 23:05] Dominic Clifton

Description:
See details below.

This bug might be related:

http://bugs.mysql.com/bug.php?id=19879

How to repeat:
steps to reproduce:

* download and install 1.06 beta and install...
* create a table using the table toolbar button
* select "utf_general_ci" as the table collation
* click the "columns" tab
* create two new fields:
* one called "id" leave everything else alone
* one called "name" leave everything else alone
- the drop-down list that should allow you to select the collaction for the "name" column is empty.

if you subsequently export the design as an sql create script this is what you get:

-- ----------------------------------------------------------------------
-- MySQL GRT Application
-- SQL Script
-- ----------------------------------------------------------------------

SET FOREIGN_KEY_CHECKS = 0;

CREATE DATABASE IF NOT EXISTS `test`
  CHARACTER SET latin1;
-- -------------------------------------
-- Tables

DROP TABLE IF EXISTS `test`.`table_01`;
CREATE TABLE `test`.`table_01` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) CHARACTER SET  COLLATE  NULL,
  PRIMARY KEY (`id`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE general_ci;

SET FOREIGN_KEY_CHECKS = 1;

-- ----------------------------------------------------------------------
-- EOF

Addtionally the table's collation does not appear in the table tab after a reload:

* save the design
* quit workbench
* start it again
* load the same design
* double click a table header
- the table's collation is not shown in the dropdown list

[30 May 2006 23:05] Dominic Clifton

fixing typo in bug title

[31 May 2006 14:08] MySQL Verification Team

Thank you for the bug report.

[22 Jun 2006 22:42] MySQL Verification Team

Bug: http://bugs.mysql.com/bug.php?id=20641 was marked as
duplicate of this one.

[9 Sep 2006 13:03] Carsten Schmitz

This bug still exists in 1.1.3alpha . Very annoying!