Characterset UTF8

[Nico van de Kamp]

Hello,

I have a csv file which I import by a query. This works fine so far, but I'm lossing special charaters and I don't know why.

For example:
In my csv file I have the name:
René
or
Antoniëlla
or
Schülski

But in the database the value is:
Ren
or
Antoni?lla
or
Sch?lski

The field is defined as:
char(15)
collatie: latin1_swedish_ci
MIME: empty

Database: MySQL Karakterset: UTF-8 Unicode (utf8)

Can anybody tell me what I have to change so that at an import of an csv file, I'm not losting the special chars.


Thanks in advance.
Nico