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

Reply via email to