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