Load special German characters-undefined ?

[scenarist]

I have a problem when I load leads for Germany. When I loaded leads with special German characters they being undefined.
I load leads in .txt tab delimited file.
How can I fix it, any suggestion or advice ?

[williamconley]

that shows how they are messed up in the web form ... (good posting to show the problem clearly!). But are the characters still messed up in the database and on the prospect information are of the lead when the agent sees the data?

you could also try using the command line lead-loader to see if the experience is different there.

[crossfirext]

1. from excel format save as.. text(tab delimited)
2. Install notepad++
3. open previous saved document in text(tab delimited) with notepad++
4. in top of notepad++ click ENCODING than Convert to UTF-8
5. save document
6. load leads again.

[scenarist]

Thank you for your answer but it is partly correct.
But when you go to Lists > Search for A Lead you got again the same undefined German Characters

[crossfirext]

I try to put two images to show you that i doesn't have that problem in search leads but im new user and when i try to put images i got this message:
"Your post looks too spamy for a new user, please remove off-site URLs."

[scenarist]

Please use http://tinypic.com/ , upload you images and copy paste url link for forums.
If you have a skype ID , please send me it to private message.

[DomeDan]

Might be a bad file you got, open up the file in notepad and notepad++, does those show the bad characters?

I had a similar issue once, I had to do a search-and-replace in the file, copy the bad character and replace it with ü

or you can do it in mysql, this is what I had to do because I didn't notice the bad fields before I imported it and started using it:
SET first_name = REPLACE(first_name,'Ø','Ø') WHERE list_id = '1234' and first_name like '%Ø%';
In my case Ø was displayed as Ø in the mysql table

[ciacho]

Fix:
http://www.vicidial.org/VICIDIALmantis/view.php?id=792