UBB.threads PHP Forum Software Community Forums UBB.threads Importer Support Classic Import - truncating posts with apostrophes

I imported a classic forum last night and it appears that posts with apostrophes were cut off at the apostrophe.

Or is it an issue with the forum - when I edit the post and put the whole post in, the data doesn't change - it's still cutting off right before the apostrophe.

???

I've been working with someone else with a similar issue but with different characters. I've debugged it clear down to the native php level on what it's committing to mysql and it sends the whole post for the insert but it doesn't store it.

Do you have access to something like phpmyadmin on the server? If so, can you try doing an insert of the whole post in there and see if it takes?

yes, once sec

hmm...

it kept truncating the text when I put it in the POST_DEFAULT_BODY, when I put it in POST_BODY all the text just showed up run together (no spaces, ubbcode didn't work, etc.). If I tried to edit the post within the forum it re-truncated.

I posted the content into POST_DEFAULT_BODY once more and then noticed in the forum the apostrophe and hyphen were giving me weird symbols - thinking it may be a character set issue I went to the control panel and changed charset from iso-8859-1 (or something like that) to utf-8

Things seem to be ok now, I can edit the post and all data stays.

I may need to re-import, but at least things are looking better, what do you think about the 'cure'?

I think you're probably good now. Like I said, I had the one other customer with the same issue. I'm trying to figure out if it's a certain mysql setting or version where this is a problem. Since it's doing it even through phpmyadmin with direct updates there must be something in particular with mysql or the charset.

hmmm... I can at least edit topics and use apostrophe's, but the importer is still truncating the topics :smash:

Does the importer not use the charset of the forum?

the problem is classic for most people is set at

ISO-8859-1

importing into mysql with a charset of utf-8 is where the truncating is happening.

It's running on

PHP: 5.2.0

Apache: 1.3.37 (who still runs this?)

MySQL:
Server version: 5.0.32-log
MySQL client version: 4.0.20
MySQL charset: (utf8)

Not the most current versions, but meets criteria.

lol a lot of ensim based webhosts still use apache1.3 and mysql4.0

Hmm, what is the collation set to on the individual UBB.threads tables?

utf8_general_ci

for all of them.