Last modified: 2009-07-31 21:06:28 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T19910, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 17910 - Database error when using japanese characters
Database error when using japanese characters
Status: RESOLVED DUPLICATE of bug 11812
Product: MediaWiki extensions
Classification: Unclassified
Semantic MediaWiki (Other open bugs)
unspecified
PC Linux
: Normal major (vote)
: ---
Assigned To: Markus Krötzsch
http://jp.bishokubase.org
: utf8
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-03-10 16:26 UTC by Marc
Modified: 2009-07-31 21:06 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Marc 2009-03-10 16:26:20 UTC
When using japanese characters as property name or value, it leads to the following error:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted  database query was:
    (SQL query hidden)
from within function "SMW::getSMWPageID". MySQL returned error "1267: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (localhost)".

After changing the collations of all smw-table fields from "latin1_bin" to "utf8_general_ci" everything was fine. I couldn't find any problems caused by this solution. So it seems it might be a good idea to have them being created using these collations at the time of installation.
Comment 1 Siebrand Mazeland 2009-05-17 21:52:34 UTC
-patch -easy
Comment 2 Markus Krötzsch 2009-07-31 21:06:28 UTC

*** This bug has been marked as a duplicate of bug 11812 ***

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links