https://bugzilla.wikimedia.org/show_bug.cgi?id=17910
Summary: Database error when using japanese characters
Product: MediaWiki extensions
Version: any
Platform: PC
URL: http://jp.bishokubase.org
OS/Version: Linux
Status: NEW
Keywords: easy, patch, utf8
Severity: major
Priority: Normal
Component: Semantic MediaWiki
AssignedTo: [email protected]
ReportedBy: [email protected]
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.
--
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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
