Check http://jira.xwiki.org/jira/browse/XAOFFICE-55?focusedCommentId=56510&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_56510
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 > [email protected] > http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
