change from windows 1225 to utf8 in mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
tpr
Forum Newbie
Posts: 2
Joined: Sun May 18, 2008 2:25 pm

change from windows 1225 to utf8 in mysql

Post 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.
tpr
Forum Newbie
Posts: 2
Joined: Sun May 18, 2008 2:25 pm

Re: change from windows 1225 to utf8 in mysql

Post by tpr »

Hi,
sorry to be bumping this but i really am stuck with this.

Thanks
dml
Forum Contributor
Posts: 133
Joined: Sat Jan 26, 2008 2:20 pm

Re: change from windows 1225 to utf8 in mysql

Post 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?
Post Reply