MesterPerfect
Active member
Hello,
I'm facing a persistent issue when importing databases from vBulletin to XenForo 2.x. This issue specifically affects databases with a character set of latin1 or latin1_swedish_ci and involves Arabic text.
I'm facing a persistent issue when importing databases from vBulletin to XenForo 2.x. This issue specifically affects databases with a character set of latin1 or latin1_swedish_ci and involves Arabic text.
The Problem:
- When importing, Arabic text either:
- Appears as unreadable characters, like this:
Code:ÇáãæÇÖíÚ ÇáÏÚÇÆíÉ æãæÇÖíÚ ÇáÇÚáÇäÇÊ ÊÖÇÝ Ýì ÇáÞÓã ÇáãÎÕÕ á
- Shows up as a series of question marks:
Code:????????????????????
- Appears as unreadable characters, like this:
Observations:
- When using XenForo 1.5 (XF1.5) for the import, the process works perfectly, and Arabic text is imported without issues.
- However, in cases where forums have been upgraded to vBulletin 5.x, it's not possible to use XF1.5 for the import, leaving no workaround.
What I've Tried:
- Ensuring the database character set is set to latin1 during the import process.
- Attempting conversions to utf8 before and after the import.
- Manually setting SET NAMES to latin1 during the import.