I upgraded from MySQL Version: 4.0.27 to MySQL 5.0.44 today. Everything runs ok but I am having some issues.

If I cut and paste text that includes ' or " in a product description or ez page, My ZC does not display any text after those symbols.

ex:
There have been no statewide opinion polls published on the bailout request, though with Michigan’s economy so tied to the industry.

ZC displays in browser :

There have been no statewide opinion polls published on the bailout request, though with Michigan

because :

’s economy so tied to the industry. is not put into the db.


other issues are:

Foreign characters.... from a little digging it seems to be ZC and the text encoding:

ex.: in old db : V‰nersborg
in new db: Vänersborg

browsers display : Vänersborg

if I change the view in firefox's browser: View->Character Encoding-> from western charset=iso-8859-1 to UTF-8 the browsers displays ok:

Vänersborg

Did I miss some upgrade step with ZC when upgrading to 5?

Should I revert back to MySQL Version: 4.0.27 ? Im a bit worried here.

I am running Zen Cart 1.38a ENGLISH only on PHP Module Version: 5.2.6