tpr
Sat 5th Apr '08, 5:00am
Hi,
I'm trying to import a phpbb2 board that uses charset windows-1225 to the current vbulleting board (that uses utf-8) however all the hebrew text get scrambled.
Now, I used phpmyadmin to import the old database into my new mysql (same server, different dbs). This works fine and im able to view both databases ok (including hebrew). The only difference is :
my vbulletin db : utf8_general_ci
while phpbb2 db uses : hebrew_general_ci
Somewhere during the impex import process the hebrew get scrambled. I tried to use the advance target/source in the impex source file however, they only relate to the charset and not the collation (is there a real difference here?) and in any case, if i place "utf8_general_ci" in the target collation i get an error.
Please advise,
Guy N.
I'm trying to import a phpbb2 board that uses charset windows-1225 to the current vbulleting board (that uses utf-8) however all the hebrew text get scrambled.
Now, I used phpmyadmin to import the old database into my new mysql (same server, different dbs). This works fine and im able to view both databases ok (including hebrew). The only difference is :
my vbulletin db : utf8_general_ci
while phpbb2 db uses : hebrew_general_ci
Somewhere during the impex import process the hebrew get scrambled. I tried to use the advance target/source in the impex source file however, they only relate to the charset and not the collation (is there a real difference here?) and in any case, if i place "utf8_general_ci" in the target collation i get an error.
Please advise,
Guy N.