Problems with character

[Stefano Moncelli]

Hi to everyone.

I have installed mysql-5.0.6-beta-nt and I have created this table:

CREATE TABLE `test` (
`name` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8

If I try to insert string with latin1 character:

insert into test values('cliché');

mysql insert into table only

clich

Someone knows the reason of this behaviour and how can I resolve this problem?

Thank you to everybody and regards,

-- Stefano