Special characters lost on csv import

This works fine for me - I pasted your text directly into a file, added the tabs between the values, and imported - the full first name ØRJAN shows in the raw table, and in the view of the table.

What platform (Unix/Mac/Windows) are you importing on? What platform did the file originate from? You might have a line-ending issue here - try adding

php_value auto_detect_line_endings On

to your .htaccess file.

I am having a similar problem, but with French special characters such as « and é, and in my case the special character and everything that appears afterwards in the cell is dropped.

For example:
First nations of Quebec entrepreneurial forum «achieving success by sharing»
becomes:
First nations of Quebec entrepreneurial forum

I tried modifying .htaccess as suggested and it didn't work. I am using xampp on Windows 7.

Module Importer will solve this problem.

I have a similar issue here. As matter as a fact, I import the same data to my local Drupal using Table Wizard, the special characters in the beginning of each item is there. But when I import the same data to another Drupal system (running in Linux), the special charactors in the beginning of each item is lost.

Does anybody have ideas why this happened? Thanks in advance!

I made it working after I saved the items in csv file with below format:

"column1","column2"
"@$%","@&*12-20"

Hope this helps.