Gossamer Forum
Home : Products : Gossamer Links : Discussions :

importing foreign characters

Quote Reply
importing foreign characters
I'm importing text from a csv file into the database using Andy's custom data import script.

The European characters are being imported incorrectly although they were right in the csv file.

Has anyone solved this problem? Is there a piece of code that can be added to the script to ensure characters are not corrupted?

Quote Reply
Re: [Alba] importing foreign characters In reply to
After much searching through Google, I initially thought there was a problem with the mySQL charset. Changing this made no difference so I took another look at the csv file- it was in UTF-8.

Solution: change the charset header in include_common_head.html

<meta http-equiv="content-type" content="text/html; charset=UTF-8" />