Support Forum

phpbb importer latin1 charset problem

HP Hakon Pedersen
Hakon Pedersen
Member
Member since May 2012
3 posts
May 3, 2012 · 6:38 pm · Edited

Hello

I’m trying to import my phpbb3 database to Simple-Press

I am able to import members, forum structure etc, but I have a problem with the charset. 

The text in my topics and headlines after the characters æøå aint imported, so I’m stuck with “half” centenses and headlines.

The mysql 4.1.22 databace which contains phpbb is set to latin1-swedish-ci charset, and not utf-8

The mysql 5.5.11 database which contains simple press is allso set to latin1-swedish-ci charset

 

The databases is located at my webhost, and I cannot create a new db, so I dont know if I can convert my database from latin1 to utf8

Database Settings

5 Answers

New Answer
MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
May 3, 2012 · 9:05 pm

did you try it with the utf-8 option both checked and not checked?

HP Hakon Pedersen
Hakon Pedersen
Member
Member since May 2012
3 posts
May 4, 2012 · 5:13 am

Mr Papa said
did you try it with the utf-8 option both checked and not checked?

Oh yes, forgot to tell that 🙂

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
May 4, 2012 · 5:50 am

Would you be willing to let me have a backup copy of the database? The best and easiest way to diagnose these issues is with something tangible to test with and is probably the only way I can resolve the issue.

if you are willing I assure you it will be uses strictly for testing purposes and will be deleted when finished with.