Multi Language Forum Text Garbled
zooki - May 17, 2009 - 12:38
| Project: | vBulletin to Drupal |
| Version: | 6.x-1.0-rc1 |
| Component: | Miscellaneous |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Jump to:
Description
Hi,
My vbulletin forum had support for several different languages, including Russian and Arabic. These were made as seperate forum categories, so they were part of the forum itself.
Having done the import, the Arabic and Russian is garbled up..
Русский
#1
Unfortunately, this probably isn't going to be an easy issue to solve.
Firstly, can you find a post that is garbled, then locate it in the Drupal database? It'll either be in the comment or node_revisions table. Is it garbled in the Drupal database?
The Drupal database using utf8 character encoding whereas vBulletin just uses the MySQL default (utf8 should be better in this case for multiple language support). Even though we use MySQL to move all the data, the problem might be due to converting between the two character encodings. If this is the case, the vBulletin database will probably have to be converted to utf8 before conversion.
#2
Does this look familiar: http://forums.mysql.com/read.php?103,25921,25921#msg-25921 ?
If you have time, try these instructions (but backup your data first!), then do the import: http://en.gentoo-wiki.com/wiki/TIP_Convert_latin1_to_UTF-8_in_MySQL
#3
Hi,
thanks, I will take a look, although the garble is different kind of garble as mentioned in those links,
the text is in the &#number;notation.. for each character.
If i copy and paste it here, it is automatically parsed into the correct letters, it just is not on my website.