problem with moving db to new host

[genom]

I did exactly step by step of what they said that
any other options?

[Joachim Müller]

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

I uploaded the database as utf8

, as this sentence doesn't make any sense at all to me.

[genom]

so what did you mean that I need to do?

[Joachim Müller]

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?

[genom]

I looked at the mysql
its the same encodings....
utf 8 unicode
and inside the db collation hebrew_general_ci

[Joachim Müller]

Repeat:

Can we take a look at the old server as well?

[genom]

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....