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
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.
so what do I need to do that it will work out fine?
I think I already told you, didn't I:
Quote from: Joachim Müller on July 13, 2010, 09:43:47 AMYou 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 (http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#admin_language_charset)
when I put it as utf8 then it looks like this
http://www.diet2all.org/gallery/index.php
2 �����, ������ ������ �27 �������,
what to do now?
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?
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
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.
this is what it was at the start
now I set it back to iso
but still I see question marks instead of hebrew
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.
ok I've updated the script to the new version still same problem with the encoding...
http://documentation.coppermine-gallery.net/en/upgrading.htm#upgrade_14_custom_theme
its not a custom theme I only changed the logo photo...
...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.
even when I use original theme still show "????"...
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.
I uploaded it as utf 8
You did what?
I uploaded the database as utf8
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
I did exactly step by step of what they said that
any other options?
At which step does it say you need to upload your database? At which stage does it say "
use a particular charset or encoding when restoring your database on the new webhost". Clarify what you meant by saying
Quote from: genom on July 15, 2010, 05:39:49 PM
I uploaded the database as utf8
, as this sentence doesn't make any sense at all to me.
so what did you mean that I need to do?
Read up the guide that explains how to move your gallery from one server to the other and do exactly as suggested there. What else could I say? Take a look at the old server: what are the encoding settings there? Can we take a look at the old server as well?
I looked at the mysql
its the same encodings....
utf 8 unicode
and inside the db collation hebrew_general_ci
from what I understood I need to put this line
mysql_query("SET NAMES Hebrew",$result);
or something like that
in include/functions.inc.php
after mysql_connect
and before select_db
but I it gives me error....