desperate - upgrading 4.0 to 4.1 with UTF8 data

[guy katz]

hi;
i am having some problems i cant seem to overcome while migrating my data from 4.0 to 4.1
when trying to convertthe user_name table (of the table described below) i get a "ERROR 1062 (23000): Duplicate entry '' for key 1"

the steps i take to get this error are simple (and describe in the mysql migration docs from 4.0 to 4.1):
1. dump data from mysql 4.0 (i use an optimized dump e.g: --opt)
2. load the data to 4.1
3. execute "ALTER TABLE users MODIFY user_name BINARY(15);"
4. execute "ALTER TABLE users MODIFY user_name VARCHAR(15) CHARACTER SET utf8;"

i am really desperate here, i have about 2 years of data i need to migrate in a short time.
any help would be great.
thanks in advance.
Guy.

here is a "show create table" on the table i talked about:
| users | CREATE TABLE `users` (
`user_name` varbinary(15) NOT NULL default '',
`user_pass` varchar(15) character set utf8 default NULL,
PRIMARY KEY (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |



Edited 1 time(s). Last edit at 01/24/2006 05:28AM by guy katz.