collation for feild issue for special chars

[phpsharma]

Hi,

Mysql table is not inserting special chars into the feild..
like this

Mikael ,Nyström

what type collation i need to set. presentlyit is..utf8_general_ci

In addtion, my primary purpose is dumping some lname,fname,email csv into table. its stopping at these chars row.

my command is

LOAD DATA INFILE '".@mysql_escape_string($csvfilname)."' INTO TABLE tablemails FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' ESCAPED BY '' (fname,lname,email) SET id = '0',mailok='1',listid='".$selistid ."'";

Thanks in advance.

sharma

[nnichols]

What error is mysql reporting when it fails?

[phpsharma]

no error, its stops at that line, which have special char.

[nnichols]

Does it allow you to insert those chars in a straight forward INSERT statement?