Hi
having been struggling for what seems the beginning of time I would like to share my solution to the french problem. ( nukenem is the best solution but a bit expensive)

1 - srw2d.com/sites/default/files/utf-8-zen-cartV1.3.8.pdf the bit in factory_query.php is a must

2 You can change the database collation in an existing installation in phpadmin by downloading it and doing a find and replace.

3 The reason why notepad and other text editors bugger up the code when saving as utf is because they put a hidden "BOM" marker in the file and saving as ansi still doesn't solve all the characters. The solution is UCAST Express its free and you can batch convert the files WITHOUT the bom marker get it here http://www.rotatingscrew.com/downloads.aspx

I dont know the company and THIS IS NOT SPAM.

This will save DAYS and DAYS of misery struggling believe me. Im no guru by anymeans but if your about to give up try this it works .... well it did for me.