[SOLVED] import ecoding error

[TeNNoX]

I tried to import some contacts with bin/csv/import.php, but some lines resulted in a

Code: [Select]

ERROR line 2: DB Error: unknown errorI figured out that those where the lines containing fields with special german letters in it (ü,ö,ä)

How can I fix this?
(the imported file is attached)

[JonGold]

This may have to do with your system's local text encoding.  I don't know your platform, but you should a) check the default text encoding for your shell session, and b) check the MySQL text encoding for the relevant tables.

Rest assured I've imported accented characters with that tool many times!

[Michael McAndrew]

Rest assured I've imported accented characters with that tool many times!

Spoken like a true bin/csv/import.php guru

[TeNNoX]

This may have to do with your system's local text encoding.  I don't know your platform, but you should a) check the default text encoding for your shell session, and b) check the MySQL text encoding for the relevant tables.

Rest assured I've imported accented characters with that tool many times!

I saw that the encoding in MySQL was UTF-8 and the file was iso-8859-1 or something like that.

After saving the file as UTF-8 it worked!
Thanks