problem with pictures named in hebrew when transfering a site

hello dedicated staff!

I have a question about transferring sites.

I have 2 different hostgator hosting accounts. sometimes I duplicate a site for testing purposes.

On the original site, ususally pictures are named in Hebrew, however, when I supplicate the site and upload it on the other hosting account, somewhere in the process the Hebrew characters change to symbols and the pictures don't display.

to make the transfer I zip all folders and upload the zipped file and exctract.

I tried to rename the pictures from the cpannel, but it doesn't allow me to change it.

What can I do? and why this happens?

Thanks!

  • Vaughan
    • Support/SLS MockingJay

    Hi @Fortunella74,

    Do you mean the physical filenames on the server get changed? or just the names of the files referenced in the DB itself?

    If just the DB, then it sounds like the DB doesn't have the same encoding/collation such as utf-8.

    How are you duplicating the DB?

    Thanks

  • Fortunella74
    • The Incredible Code Injector

    Well, I only looked at the files names under content upload.

    Following your answer I tried to investigate a little my db (aside from uploading I usually don't do much with it) anyway, I looked around and it seems to be ok. I see this: "utf8_general_ci" under the collation value of most tables, including wp_posts and wp_revsliders.

    the configuration file shows:

    define('DB_CHARSET', 'utf8');
    and
    define('DB_COLLATE', '');

    but again, inside db tables it looks ok.
    I received files and db compressed in zip

    Please help :slight_frown:

  • Vaughan
    • Support/SLS MockingJay

    Hi,

    Apologies on the delay.

    So,the filenames stored in the DB itself look ok?

    But the files uploaded to the server itself have the filenames altered?

    How are you uploading the files to the server,are you using an FTP client or using the CPanel filemanager?

    Could you take a few screenshots of before & after?

    Thanks

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.