CREATE TABLE `domain` (
`domain` binary(3) NOT NULL default '',
`language` enum('english','greek','german') NOT NULL default 'english',
PRIMARY KEY (`domain`)
) ENGINE=MyISAM DEFAULT CHARSET=ucs2;
I have problem with this SQL Query.
language (enum) appear in non-understanding character format instead of
english/greek/german
But if I change the CHARSET to latin1, it works fine.
Why?
What I can do?