https://bugzilla.wikimedia.org/show_bug.cgi?id=24909
Summary: mwdumper .IOException: java.sql.SQLException:
Incorrect string value:
Product: mwdumper
Version: unspecified
Platform: All
OS/Version: Windows XP
Status: NEW
Severity: enhancement
Priority: Normal
Component: general
AssignedTo: br...@pobox.com
ReportedBy: crajapa1...@gmail.com
I am trying to convert the japanese wikipedia's xml dump to sql file with
mwdumper and "jawiki-latest-pages-meta-history.xml",
But I get a Java exception, and it doesn't work...
the message is that:
-----------------
Exception in thread "main" java.io.IOException: java.sql.SQLException:
Incorrect
string value: '\xF0\xA1\x9A\xB4' for column 'rev_user_text' at row 5014
-----------------
the status of mysql on my PC is like a following:
--------------
mysql Ver 14.14 Distrib 5.1.50, for Win32 (ia32)
Connection id: 4
Current database: wikidb
Current user: r...@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.1.50-community MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 52 min 20 sec
Threads: 1 Questions: 1594 Slow queries: 1 Opens: 379 Flush tables: 1 Open
tables: 3 Queries per second avg: 0.507
--------------
I don't understand very much about MySQL or Java, so it can be a simple
problem.
But I could not solve this by myself.
So, please tell me what happens and how to solve.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
