Ipb 2.3 to smf 1.1.5 - problems with utf-8

[speaker]

I converted everything from existing Ipb 2.3 to smf 1.1.5.. MY board language uses Unicode...but I see symbols like "áƒ".....any chances to correct this? The DB collation in Phpmyadmin is set to utf-8...during install of smf I checked utf-8....what next?

[ThorstenE]

are both forums utf-8? (same DB?)  if Ipb is latin you should install SMF in latin and after successfull conversion change it via ACP to UTf-8.

[speaker]

Hi, ThorstenE. The IPB is latin, but I simply replaced the English folder in cache/lang_cache with the other one, in other language...Does it matter?

are both forums utf-8? (same DB?)

well they are on both server but different DBs. but in fact, the collations on both db-s are set to utf-8.

[ThorstenE]

The IPB is latin

A possible solution would be to replace all symbols to the correct signs but it's a hard job because you need to fix many tables with many fields.

a small example how to do this (with german umlauts)

Code Select Expand

update smf_messages set body = replace(body,'ä','ä');

but it would be much easier to convert your IPB in latin based collation SMF  and after successful conversion change it to UTF-8.

[speaker]

Thank you, I'll try something with this solution.