SS CMS error when pasting and updating pages

I get the error "Incorrect string value: '\xE2\x80\x9CBMG...' for column 'HistoryValue' at row 1" when pasting and updating pages using CMS installed via Site Sculptor.

Could someone please tell me how to resolve this problem?

are you copying the content from Word?

if so make sure to use the paste From word toolbar icon to clean the content up.

the paste from world toolbar icon is the clipboard with the Word "W" logo.

Yes, I have posted from Word and its still giving the same error.

Pasted in Komodo Edit and changed the encoding on the file settings to UTF-8 and pasted in the CMS..... still giving error. Went to the database file (pcms2_contenthistory) via Navicat to the concerned under the HistoryValue column and pasted there .... still same problem (throws up error 1366). Checked with database encoding and selected UTF-8 Unicode/utf8_general_ci and still not working. Tried latin1/latin1_swedish_ci and still throws up the error.

I could have pulled off my hair (if I had any) by now and really do not know what else to try. When my client types the content in, it updates but pasting simply does not work.

well, what is the content you are pasting?

Pasting website privacy policy (5 pages long)

it's possible it may be to long to post into the content field.


try pasting it into a text file to clean the content up, then copying it from the text file then into Power CMS


you may also need to break it up into smaller pieces.

Tried again to paste from Komodo in bits and pieces and still didn't work.

Now tried in bits removing all the bullets and it worked. Strange that MySQL does not recognize bullets. Well, worked till I got to the last part (smallest chunk) of the document and still not working. Cant seem to identify what character(s) is causing this?

Since its the recognition of certain characters that's creating the problem, is there a way round this with MySQL?

It could have something to do with your charset definition either

1) on the html page
2) in the database itself
3) in the database connection

You could try adjusting those charsets to see if you could find one that works. The html page you can change the charset in a meta tag. The mysql database and tables have a query you can run on the database to change the charset, and the connection can be set with the mysql_set_charset() function (this is exposed in our dynamic connections extension if you don't want to figure out how and where to add it manually).

You could test if it is the database itself by seeing if you can enter those characters directly in the database using mysql myAdmin. Adjust the charset settings with code like:

alter database [enter your database name]charset=utf8;
ALTER TABLE pg1_gallery_images CONVERT TO CHARACTER SET utf8;

Then see if it works. Once it works in the database directly, then update the html page and connection to use the same charset.