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
