Hi,
when i try to import office documents with office importer extension , i’ve got this SQL error : “Incorrect string value: '\xD9\x84 ‘, …’ for column ‘XWR_PATCH’ at row 1”
I don’t know what it means an how to solve it, can anyone help me please ?
Here is the log error file : 2018_06_13.output.log (196.8 KB)
Hi everyone,
i found the solution of my problem , the error happens when there is a special char in a word document like this special char 
You have to remove it if you want to import the document.
Sounds like bad character encoding setup in your database.
when i move the xwiki database from hsqldb to mysql , xwiki run mysql script which create mysql tables with latin1_swedish_ci interclassement
The right one is utf8_bin. See http://www.xwiki.org/xwiki/bin/view/Documentation/AdminGuide/Installation/InstallationWAR/InstallationMySQL/.
Ok, thank you , how can i do know to change it without lost everything i’ve done ?
An example how to convert encoding is on the page that @tmortagne linked to:
Backup your DB before you start!
Thank you,
i think it’s a linux scprit and i’m on windows.
Do i have to run it in a page in xwiki or , in mysql or in the server please ?
Hi, i have done a new database with utf8-bin encoding but i still have the same error message
i don’t understand the reason, could you help me please ?
Hi everybody , any ideas please ??