Strange problem with contact import

[dennisbwest]

When trying to import contacts from csv file I get question mark characters showing up in the data. For a one person one field (last name) import I got "C�u�r�t�i�s�J�o�h�n�s�o�n�" as the value in the field. But the value in the text file is "CurtisJohnson".

Runnining with:
Linux
MySQL4 4.1.9
Php 4.4.2
Sugar 4.5.1f

[Angel]

How are you creating that CSV file?

Does the same thing occur if you import a different, manually created CSV file with a couple of the same contacts?

[dennisbwest]

With a text editor. It has no unusual characters.
Looks like this:
last_name
CurtisJohnson

I also tried it with quotes around values.


Thanks for thinking about it.

[dennisbwest]

Thanks for helping me.
While I was using a text editor to edit the file and there did not appear to be any extra characters in the file, there must have been something wrong with the file because I made a new file with some test data and it worked.

[kuske]

Your csv-File seems to be coded in a double byte charset.
So each second character is a 0x00 character.
Most editors do not show this
Open the csv-file in a hex-editor and you will see this.
Perhaps you generated the csv-file with a doublebyte charset option?

regards
hk