Problem using 'ä,ö,å' in MySQL

I can't seem to figure out how to get my database to accept scandinavian
characters. A source file example:

CREATE TABLE IF NOT EXISTS `scantest` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`scandicletter` VARCHAR( 30 ) NOT NULL
) ENGINE = innodb CHARACTER SET utf8;
INSERT INTO scantest (id, scandicletter) VALUES (NULL, 'Ääää');
INSERT INTO scantest (id, scandicletter) VALUES (NULL, 'Öööö');
INSERT INTO scantest (id, scandicletter) VALUES (NULL, 'Åååå');

when run in MySQL Client yields the following:
'Query OK, 0 rows affected' for create table and
'ERROR 1406 (22001): Data too long for column 'scandicletter' at row 1'

The same happens with all charsets, at least the more common ones I have
tried. Net search showed some people having the same problem but solutions
mostly stated that it is "Windows-related" and did not help for me.


 - Marek

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]