From: Martijn Tonies
Date: December 10 2003 1:05pm
Subject: Re: MySQL 4.1.1 Internationalization (ENUM)
List-Archive: http://lists.mysql.com/mysql/155413
Message-Id: <04eb01c3bf1e$5857f7b0$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: 8bit

Hi,

> create table t(a enum ('Îäèí','Äâà','Òðè'));
> show create table t;
>
> CREATE TABLE `t` (
>   `a` enum('????','???','???') default NULL
> ) TYPE=MyISAM DEFAULT CHARSET=cp1251
>
> and this is a bug!

But a bug in what?

I've created the table with Database Workbench, and when doing
a SHOW CREATE TABLE t; It displays:

CREATE TABLE `t` (
  `a` enum('Îäèí','Äâà','Òðè') default NULL
) TYPE=MyISAM

Which sounds fine to me (except the charset thingy, I'm running 4.0).

Perhaps it's a bug in your client tool?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com