Last modified: 2009-07-31 21:06:28 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.
-patch -easy
*** This bug has been marked as a duplicate of bug 11812 ***