problem with moving db to new host

[genom]

I am using hebrew letters
after I uploaded the db to the new server it shows ?? letters instead of hebrew
what is the problem with the encoding?
http://www.diet2all.org/gallery/index.php

[Joachim Müller]

You have set the charset in coppermine's config to iso8859-1. It's not surprising that this happens then: iso8859-1 can of course not display hebrew chars. If the content from your database is in utf-8, you need to set the config option back to utf-8 as well. Looks like you haven't performed the move as you should have done, but instead you appear to have performed a fresh install and a merge of the database and files afterwards. That's not how you should perform a move to another server. Not related to initial install - moving accordingly.

[genom]

so what do I need to do that it will work out fine?

[Joachim Müller]

I think I already told you, didn't I:

You have set the charset in coppermine's config to iso8859-1. It's not surprising that this happens then: iso8859-1 can of course not display hebrew chars. If the content from your database is in utf-8, you need to set the config option back to utf-8 as well.

Documentation -> Config -> Character encoding

[genom]

when I put it as utf8 then it looks like this
http://www.diet2all.org/gallery/index.php
2 �����, ������ ������ �27 �������,

what to do now?

[Joachim Müller]

Well, then use the encoding you originally used to create the content in the first place. Maybe you used to have it set to Hebrew (iso-8859-8-i)? How should we know what your settings used to be?

[genom]

but it is iso hebrew already
and in the database you cant use this encode only utf or hebrew ci /hebrew bin or something like that
so I dont know what to do

[Joachim Müller]

Right now your encoding is set to utf-8 and not to iso-8859-8-i. Set it explicitely to iso-8859-8-i in Coppermine's config.

[genom]

this is what it was at the start
now I set it back to iso
but still I see question marks instead of hebrew

[Joachim Müller]

Maybe you should update your gallery for a start to make sure that this is not related to an issue that already was fixed. You're running behind many versions.

[genom]

ok I've updated the script to the new version still same problem with the encoding...

[Joachim Müller]

http://documentation.coppermine-gallery.net/en/upgrading.htm#upgrade_14_custom_theme

[genom]

its not a custom theme I only changed the logo photo...

[Joachim Müller]

...which is what makes it a custom theme. It's a theme theme that was designed for cpg1.4.x that can't be used with cpg1.5.x without performing the modifications that I refered to. I'm not posting this without a reason.

[genom]

even when I use original theme still show "?"...

[Joachim Müller]

I didn't say that your initial issue will go away if you perform the upgrade properly. It's you who rolled several issues into one.
Use a third party tool like phpMyAdmin to directly access the database content. Find out in what encoding the database's textual content has been written.

[genom]

I uploaded it as utf 8

[Joachim Müller]

You did what?

[genom]

I uploaded the database as utf8

[Joachim Müller]

I have no idea what you did - you can't do what you claim to have done. You must have gotten something wrong. Maybe you should re-apply the move from the old server to the new one, doing as suggested in http://documentation.coppermine-gallery.net/en/export.htm#moving_server