• Registered: 2009-01-04
  • Posts: 3

Topic: Encoding problems after upgrade to 1.3

Hi,
sorry but i don't find any solution in older post.

I have upgrade my punbb 1.2 to 1.3. It's all right but now i see strange characters in my board (like 'à iù! ì).
This character is also in posts table of db (with "utf8_general_ci collation").

With punbb1.2 and db =  utf8_general_ci collation (with à characters also in posts tables) it's ok, character are automatically converted.
With punbb1.3 and db =  utf8_general_ci collation (with à characters also in posts table) it's not ok and the wrong characters are show.

I'm a lot confused about UTF-8, encoding, etc.., can someone help me?

I work on local system for now, so i can do all to solve it.

Sorry for my bad english.

  • YonasH
  • PunBB Extensions Dev.
  • Offline
  • From: Dublin, IE
  • Registered: 2007-02-10
  • Posts: 148

Re: Encoding problems after upgrade to 1.3

I'm not specialist in encoding stuff, but it's looking like browser is diplaying page in some ISO(latin) encoding.
Check what is your page encoding in your browser. Try to force it to UTF-8.

YonasH's repository + Extensions Directory = PunBB Extensions Online Library (in progress....)

Away. I will be back soon.
  • Registered: 2009-01-04
  • Posts: 3

Re: Encoding problems after upgrade to 1.3

Hi yonash, thanks for the reply.
My browser is allready set to UTF-8.

4 Reply by MattF

  • MattF
  • Senior Member
  • Offline
  • From: South Yorkshire, England
  • Registered: 2007-03-15
  • Posts: 1,956

Re: Encoding problems after upgrade to 1.3

Has the content actually been stored as UTF-8? The database type won't automatically alter the content, so if it was stored as, for example, one of the Latin character formats, you'll need to convert the content. If you do a search on here for 'Spanish', there's info on how to run iconv on a database dump. smile Other than that, I can't think of anything else offhand.

MattF's Website

5 Reply by RiccardoP (edited by RiccardoP 2009-01-04 18:55)

  • Registered: 2009-01-04
  • Posts: 3

Re: Encoding problems after upgrade to 1.3

Ok, thanks!
I have used iconv to convert text from UTF-8 to ISO-8859-1.

First for forum table of db.

iconv -f UTF-8 -t ISO-8859-1  forum_table.sql > ok_forum_table.sql

And now character and text in forum table is ok (and are show ok in board index). smile

But when i try to convert the posts table also, i have this error.

iconv -f UTF-8 -t ISO-8859-1  posts_table.sql > ok_posts_table.sql 
iconv: illegal input sequence at position 1719812

6 Reply by MattF

  • MattF
  • Senior Member
  • Offline
  • From: South Yorkshire, England
  • Registered: 2007-03-15
  • Posts: 1,956

Re: Encoding problems after upgrade to 1.3

You want to be converting *to* UTF-8, not the opposite way around. smile As to what the cause of that error is, I can't say.

MattF's Website