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:
After conversion to PHPBB 3.0.8:
Any ideas?
Posts cut after a number of characters - SMF 1.1.x to phpBB3
Posts cut after a number of characters
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
Berlin wird immer in meinem Herzen sein Auf wiedersehen, Berlin!
Der Mensch schuf Gott nach seinem eigenen Bild
-
- 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
Re: Posts cut after a number of characters
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.
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?
-
- Former Team Member
- Posts: 11812
- Joined: Tue Jan 25, 2005 8:38 pm
- Location: New Hampshire, USA
- Name: Richard Foote