swedish characters in load data into table

I (a total newbie on sql) try to populate my tables by load data local -syntax from a text file (saved in ANSI-coding) with swedish characters (vocals å ä ö), but select * from table reveals that swedish vocals are replaced by other signs. If I load manually by insert into table values-syntax all

The Swedish Vocals?

Hi, I asked yesterday about how to get swedish vocals (åäö)when using *load data local infile file.txt into table* syntax. The file.txt is written with swedish vocals and saved in unicode format, the OS is Windows 2k and the mysql version is 4.0.18-max-debug. The vocals are replaced with other