23 Mar
2011
23 Mar
'11
10:36 p.m.
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