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 swedish vocals are there.
How can I load from a textfile, getting my characters? Magnus W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]