I have an issue when converting from my old phpBB 2 board.
This is a portuguese board and after conversion, on my phpBB 3 board, I cannot see the accentuaded characters, all is messed up.
Hi!
I think I have the same problem.
I just converted my site grom phpbb2 to phpbb 3.0.12, and everything looks fine except from some special characters.
For example I get problems with the ñ, ¿, ¡, á, é, í, ó, ú, etc
Actually, I just downloaded and installed the Spanish language pack and the problem persists. So I think it must be encoding-related.
What I think I'll do, is to find and replace text in the database tables. I'm planning on using this tutorial for it.
I did it for all the variables (columns) where special characters were present. However, there are still these characters on some places and I don't know how to replace them, for example in the forums descriptions.
Does anyone know how can I modify this text?
On the MYSQL tables, instead of the text itself I see for "forum_desc" values such as "[BLOB - 51 B]"
I don't know where the real text is, or how to find and edit these entries.
Anyone can help?
Thank you in advance!
Last edited by marianave on Tue Nov 04, 2014 2:10 am, edited 1 time in total.
-In PHPmyadmin Open the table where the BLOB info is
-Go to the "Structure" tab
-Change the desired column from utf8_bin to utf8_General_ci (using the "edit" pencil)
-The text will show!
-Search and replace as exemplified in the previous post
-Change the column back from utf8_General_ci tp utf8_bin
That's all!
It worked for me, I hope it works for you too