Bug #19485 Cannot define "CHARECTER SET" AND "COLLATE"

• Submitted: 2 May 2006 16:40
• Modified: 2 May 2006 20:17
• Reporter: John Greene
• Status: Won't fix
• Category: MySQL Workbench Preview
• Severity: S3 (Non-critical)
• Version: 1.0.06 Beta/1.1.1-alpha
• OS: Windows (Windows XP SP2)
• CPU Architecture: Any

[2 May 2006 16:40] John Greene

Description:
Cannot set the CHARECTER SET AND COLLATE options.

The Exported SQL script returns NULL; when you run the sql script an error message is produced.

The following is an example of a exported SQL Script:

-- ----------------------------------------------------------------------
-- 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`.`STUDENT_TBL`;
CREATE TABLE `test`.`STUDENT_TBL` (
  `idtable_01` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) CHARACTER SET  COLLATE  NULL,
  PRIMARY KEY (`idtable_01`)
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE bin;

SET FOREIGN_KEY_CHECKS = 1;

------------------------------------------------------

The attribute "name" has blank CHARECTER SET = BLANK
and COLLATE = NULL.

Result:
------

Cannot build table from generated SQL Script

How to repeat:
1. Create a Table
2. Add attributes
3. File ---> Export ---> Export SQL Create Script

[2 May 2006 17:37] MySQL Verification Team

Thank you for the bug report.

[12 Jul 2006 14:29] MySQL Verification Team

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