Check http://jira.xwiki.org/jira/browse/XAOFFICE-55?focusedCommentId=56510&page=co... Is OpenOffice configured to use UTF-8 when exporting office documents to HTML? Hope this helps, Marius On 03/23/2011 11:36 PM, Ramon Gomes Brandão - SERINT wrote:
Hi,
When I try to create a page from an Office Doc in XE 2.7.1 (Add -> Create a Page from Office Document), some documents succeed without problems, others get an exception caused by:
java.sql.BatchUpdateException: Incorrect string value: '\xEF\x80\xBD|(%...' for column 'XWR_PATCH' at row 1
I get this also with the same docs when I try to use the office importer macro on WYSIWYG editor.
I've searched the user list archive and found something about this was a misconfgured charset. But I've created the xwiki database with charset=utf8 just like the instructions, and double checked on mysql:
My xwiki database: +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+
My MySQL System database: +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+
The strange point is why some docs succeed, others not. I've tested a bunch of docs, and found this behaviour.
Any ideas? Is it a BUG? Other places to check? I've though at first the problem happened just with docs containing some bullets markings, but not only.
Regards,
Ramon Gomes Brandão
_______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users