3 replies to this topic

[PrinceOfAbyss]

I want to convert an old backup of a phpBB forum to IPB. The collation of the old phpBB DB is latin1_swedish_ci. So I don't know what to set in the field Database Charset when setting up the conversion in ACP. The default value is UTF8 and it suggests I shouldn't change this, but this is definitely not the correct charset I should set it to.

[PrinceOfAbyss]

According to the page Charsets in cPanel, latin1_swedish_ci belongs to this group:

latin1 (cp1252 West European) latin1_bin West European (multilingual), Binary latin1_danish_ci Danish, case-insensitive latin1_general_ci West European (multilingual), case-insensitive latin1_general_cs West European (multilingual), case-sensitive latin1_german1_ci German (dictionary), case-insensitive latin1_german2_ci German (phone book), case-insensitive latin1_spanish_ci Spanish, case-insensitive latin1_swedish_ci Swedish, case-insensitive

So, should I set the setting to latin1 (I think I tried it yesterday and gave me a IPS Database error), or cp1252? Or something else?

[teraßyte]

As long as the IP.Board database and the charset in conf_global.php are setup as UTF-8 and the phpBB converter in the ACP is setup to convert from a latin1 database (there's a setting when entering the DB details) you should be fine and the conversion script should automatically convert everything to UTF-8.


What database driver error did you get exactly?

[PrinceOfAbyss]

Let me give you some more details Tera.

This backup I'm trying to convert is the original DB we used back in 2007 before we moved to IPB. So, in 2007 I converted this same DB to IPB 2.x

My IPB DB then was also in latin1_swedish_ci and was working well with codepage iso-8859-7.

2-3 months ago I converted the codepage for my IPB to UTF8 (remember the ticket?).

So, what I want now is to re-convert the whole phpBB DB to a temp installation of IPB, then run the charset conversion script of Brandon to convert this temp installation to UTF8, and finally merge some hundreds of members from this temp IPB installation to my live IPB.

So, are you saying that I can completely skip the step of using Brandon's script to convert the charset if I use a specific setup during the conversion?

Facts so far:

I recovered the phpBB backup in a latin1_swedish_ci empty DB.
I installed a temp IPB in a latin1_swedish_ci empty DB.

Plan for later:

Convert the phpBB to IPB.
Run Brandon's script to re-encode the IPB temp to UTF8
Move some members from the temp installation to the live one.