Problem with editor cutting off text at apostrophes and quotations

[jwagner]

We have an installation of Vbulletin 4.2.1. It is connecting to MySQL 5.5. Magic quotes are turned of in PHP. The problem is whenever someone copies and pastes text from a Microsoft Word document. The default characters for apostrophe and quotation marks in Word (on all our client computers) do not appear to be the same as the apostrophe and quotation character set used in Vbulletin's CKEditor. Whenever a new forum post is created, the text will save and be cut off at the apostrophe or quotation mark. The interesting thing is if you go back to edit your post (which was cutoff) and repaste the original text, it now saves in its entirety.

I am at a loss which code, settings or templates I can check from here. I've tried changing the WYSIWYG editor to standard as well as other options in the Admin panel but it seems to have no effect. The default config.php had charset commented out. I tried uncommenting so it read utf8 but that had no effect so I commented it back out again. Any guidance on settings and code to check would be appreciated.

[jwagner]

Has anyone seen this issue before? Certainly someone has encountered a quote or apostrophe issue in Vbulletin and its editor.

[jwagner]

Anyone?

[Zachery]

Make sure your Language is set to UTF-8, instead of ISO

[nerbert]

Are you using the special paste from word feature up in the top row of editor buttons? you have to be in WYSIWYG mode to use it.

[jwagner]

Originally Posted by Zachery

Make sure your Language is set to UTF-8, instead of ISO

Thank you. The problem ended up being that a default language set of ISO-8859-1 was used upon installation and it needed to be set to UTF-8. Problem solved.

[Zachery]

This occurs when your database and everything related to it, is set to UTF-8, the odd data breaks the connection.

[AusPhotography]

Originally Posted by Zachery

This occurs when your database and everything related to it, is set to UTF-8, the odd data breaks the connection.

We are having this issue.

Our database is UTF-8 and collation is set to utf8_unicode_ci

* Server version: 5.6.21 - MySQL Community Server (GPL)
* Server charset: UTF-8 Unicode (utf8)

Is there anything we can do to fix it?

(It seems to be 8 bit characters such as ’ and • hex 92 and 95 that can cause issues)

Kym

--------------- Added [DATE]1420760106[/DATE] at [TIME]1420760106[/TIME] ---------------

Fixed. I had to change a setting for PHP and the Language setting