search

kinland / cse403-wi11-wikimap

Automatically exported from code.google.com/p/cse403-wi11-wikimap
0 stars 0 forks source link

Lack of unicode support #143

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. SELECT * FROM `wikimapsDB`.`ArticleRelations` WHERE Article="عربي";

Basically, it seems that all the unicode searches I'm trying don't work. Our 
code doesn't break - it brings us to an error page, but I don't think this is 
what we want to happen. SQL is spitting out an exception about "Illegal mix of 
collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for 
operation '=' " so I'm unable to tell whether this is in our database or not.

I've tested with
"\"", "/", "ひらがな", "漢字", "ä", "عربي"

none work. \, /, and ä don't cause SQL to break, but they dont seem to be in 
our DB either.

Original issue reported on code.google.com by dylan.ho...@gmail.com on 11 Mar 2011 at 2:54