The Swedish Vocals?

2004-03-29 Thread magnus . waller
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 si

swedish characters in load data into table

2004-03-29 Thread magnus . waller
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"-synt