Форуми / Cotonti / Support / Unable to convert sql to UTF8

musiconly
#10938 03.04.2009 07:33
I'm trying to convert sql database to UTF8 but with no success!

I'm doing it by following Lombi's great video lessons but somehow I can't fix those problematic characters. My database has been used for recording this video lesson : http://www.cotonti.com/docs/en/upgradevideos/fixing_problematic_utf8_dumps

but even though i follow it step by step I can't get characters right.

I'm using Notepad++ 5.3.1. I have splited 130mb sql file into several files making sure that they don't exceed the limit of 30MB.

When I choose Encode to UFT8 without BOM i get C4? instead of SOME characters (č) and the rest is the same - no ž,š...

I even tried encoding to UTF8 but no luck!

What's the problem?

Thanks!