2011-06-08, 05:29 PM
Hello all ...
Mybb : 1.6.3
Merge : 1.6.1
i have problem converting VB4 datebase (it was vb 3 last year we upgrade to vb 4) to Mybb 1.6.3
most of things returned But The Problem is with encoding
its arabic forum ( arabic name users, posts and threads)
its shows me symbols & unknowns things
------
when i open the backup with text editor :
1st line :
------
some misc info from inside backup :
-----
Any english words from the backup it shows ok without problem just the arabic words shows symbols things
example :
More Info about mybb database mysql :
i create new database with collation utf8_general_ci
More info about mybb merge :
when i run merge for Database i selected encoding UTF8
& i tried both (yes) & (No) choice for convert tables to UTF8 messages
Note : If there is more info needed form me tell me about it !
My Regards ...
EDIT :
more info inside phpmyadmin :
the collation of tables is : latin1_swedish_ci
i also restored the backup in my local pc but same forum (VB) it returned like same as in hosting before
i did that to make sure the database not broken or wrong converting
wow over 22,000 views
and there no reply !
that's sad
Mybb : 1.6.3
Merge : 1.6.1
i have problem converting VB4 datebase (it was vb 3 last year we upgrade to vb 4) to Mybb 1.6.3
most of things returned But The Problem is with encoding
its arabic forum ( arabic name users, posts and threads)
its shows me symbols & unknowns things
------
when i open the backup with text editor :
1st line :
MySQL dump 10.13 Distrib 5.1.56, for unknown-linux-gnu (x86_64)
------
some misc info from inside backup :
/*!40101 SET character_set_client = utf8 */;
ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
-----
Any english words from the backup it shows ok without problem just the arabic words shows symbols things
example :
ÇáãäÊÏì ÇáÚÇã
ÇáãÑßÈÜÇÊ æÇáÓíÇÑÇÊ ÇáãÚÏáÉ
More Info about mybb database mysql :
i create new database with collation utf8_general_ci
More info about mybb merge :
when i run merge for Database i selected encoding UTF8
& i tried both (yes) & (No) choice for convert tables to UTF8 messages
Note : If there is more info needed form me tell me about it !
My Regards ...
EDIT :
more info inside phpmyadmin :
the collation of tables is : latin1_swedish_ci
i also restored the backup in my local pc but same forum (VB) it returned like same as in hosting before
i did that to make sure the database not broken or wrong converting
wow over 22,000 views
and there no reply !
that's sad