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
23 Mar
23 Mar
11:07 p.m.
Check
http://jira.xwiki.org/jira/browse/XAOFFICE-55?focusedCommentId=56510&pa…
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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
24 Mar
24 Mar
12:56 a.m.
On 03/23/2011 10: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
This means that the database is expecting UTF8, but it got latin1 data.
Somewhere along the way the wrong encoding is used.
As an experiment, what does this print: (put it in a wiki page)
{{groovy}}
print System.getProperty('file.encoding');
{{/groovy}}
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:
--
Sergiu Dumitriu
http://purl.org/net/sergiu/
5023
days inactive
5023
days old
2 comments
3 participants
participants (3)
-
Marius Dumitru Florea -
Ramon Gomes Brandão - SERINT -
Sergiu Dumitriu