problem with creating new albums and photos in hebrew characters

[genom]

I save them and it shows them in question marks
I had problem in the past that the whole database in the new server showed the characters as question marks so I did this:
edied the file
include/functions.inc.php
put this line
      mysql_query("SET CHARACTER SET hebrew",$result);
after  function cpg_db_connect()


I did this to force the database to be in hebrew

but what do I need to do now in the functions file to force new albums and photos to be showed right?

thanks

[papukaija]

Please post a link to your gallery as requested by board rules.

[genom]

this is the link to the gallery
http://diet2all.org/gallery/index.php

the strange thing is the second gallery works fine:
http://diet2all.org/dietme/gallery/index.php

but I moved them from different servers


I tried to change the database encode
charcterset
collation
nothing worked

[papukaija]

Why didn't you use this [ur=http://documentation.coppermine-gallery.net/en/configuration.htm#admin_language_charsetl]setting[/url]? Did you read the warnings from that page? You should also upgrade your gallery to cpg 1.5.8

I think that you are now out of support:

In short terms: Do not change the encoding in Coppermine from utf-8 to anything else unless your really, really know what you're doing and if you understand that this decision will mean that you will get unsupported as far as language issues are concerned.

(from here).

You might be able to solve this issue by setting setting the encoding to utf-8 and then playing with phpmyadmin (be aware, phpmyadsmin is not supported in this forum).

[genom]

I already upgraded it to the lastest version
so to change it to utf8?

[papukaija]

so to change it to utf8?

Try, but use the setting from your gallery's settings, not in the code.

[genom]

still not working it shows strange letters

[Αndré]

but I moved them from different servers

You need to set the encoding as it was on the old server.

[genom]

it was the same...
I tried every possible way that I know to fix it
even changing the encoding inside the database itself (the backup I uploaded)
maybe its a bug?

[Αndré]

It's no bug, but an individual issue. It works for a lot of users (even for one of your galleries). So it depends on your dump file or the export/import. Have you looked directly in your database if the characters are messed up there, too?

[genom]

I looked there they look different
the working db has letters like this:
ֳ—ג€ֳ—ֵ¾ֳ—ֻœֳ—ג€¢ֳ—ֲ₪ֳ—ֵ
and the one with the problems is like this:
'׳"׳ž׳˜׳•׳₪׳œ׳™׳ ׳©׳œ ׳ž׳¨ ׳™׳¢׳§׳' ׳¢׳–׳¨׳


I think they have difference right?

[Αndré]

Seems that your source database / dump file and the new database server are using a different encoding. That's no Coppermine issue. I'm not familiar with hebrew. I had some troubles in the past with German umlauts, as my database stored the data in latin1, but Coppermine uses utf-8. So the >1 byte characters get messed up. I'm not sure how I solved that, but I think I tried to use different encodings while exporting/importing my database with MySQLDumper. Good luck

[genom]

where can I get this mysqldumper?

[Αndré]

http://www.mysqldumper.net/