MySQL Collation Problem

[uae2k]

I have finished upgrading my PP version to the version 5.31

I'm using vBulletin for the users database

I was using my local mechine in the upgrading and every thing is OK

after uploading the files and the database to the server I have faced a problem ... every value comes from the database comes like ?????

My PP in Arabic language
I'm using cp1256_general_ci as collation and I have tried saveral collations with any result

I have tried to edit my.cnf and assign cp1256_general_ci as default character but the same problem will appear in the vBulletin which it in the same server

[uae2k]

mysql> show variables like 'colla%'
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+

[Chuck S]

Thats a mysql issue and not photopost

It would appear to me your collation is set on your local machine to one thing and your server it is another and your having issues trying to reinsert the data back into the proper database correct.

I would suggest you make sure the collation is set to the same as your server and then do an upgrade or simply do the upgrade the traditional way by upgrading the database on the server