SMF 1.1.x to phpBB3

Posts cut after a number of characters - SMF 1.1.x to phpBB3

Posts cut after a number of characters

by HuanManwe » Sat Jan 22, 2011 12:39 pm

Hello.

It's not the first time I've seen this but now a user is asking, in the Spanish Support Forum, why the posts converted are cut.

SMF 1.1:
Image

After conversion to PHPBB 3.0.8:
Image

Any ideas?
Moderator in the Spanish Official Support Forum and Translator of the Spanish language pack with the help of www.phpbb-es.com | Ayuda en español.
Berlin wird immer in meinem Herzen sein :) Auf wiedersehen, Berlin!
Der Mensch schuf Gott nach seinem eigenen Bild
User avatar
HuanManwe
Registered User
Posts: 235
Joined: Wed Dec 29, 2004 9:43 am
Location: Málaga (Spain) [European Union] - Earth - Solar System - Milky Way - Local Group - Universe
Contact:

Re: Posts cut after a number of characters

by D¡cky » Sat Jan 22, 2011 6:44 pm

This is a MySQL "feature" that when inserting text into the database, MySQL cuts off the text when an invalid utf8 character is encountered.

Unfortunately, there is no easy fix. What is needed to be done is match the database collations with the language encoding. There is some talk about this in the SMF Convertor topic. You could try changing the database to utf8 or if it is already utf8, change it to latin1. If it is just that one character that is causing the problem, you could try changing that character in the SMF database.
Have you hugged someone today?
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact: