Page 1 of 1

change from windows 1225 to utf8 in mysql

Posted: Sun May 18, 2008 3:01 pm
by tpr
Hi,
I have an old site which uses coppermine gallery with charset 1255. In order to upgrade to the newest version I needed to switch to UTF8. In order to do that, I exported the db, transformed the text to UTF8 and imported it back.
Currently when I use phpmyadmin (in utf8) the text (in hebrew) looks perfect. However when I try to view the text through the coppermine gallery (while setting encoding to utf8) i get ??????.
What am I missing ?

Guy N.

Re: change from windows 1225 to utf8 in mysql

Posted: Wed May 21, 2008 10:21 am
by tpr
Hi,
sorry to be bumping this but i really am stuck with this.

Thanks

Re: change from windows 1225 to utf8 in mysql

Posted: Wed May 21, 2008 4:13 pm
by dml
When you reimported after the conversion to utf8, did you prefix with "set names utf8" so the database knew to interpret the data as utf8?