encoding - how-to query mysql utf-8 table using ASCII -


i have created mysql 5.6 table column encoded in utf-8, characters in romanian, czech, hungarian, polish, french, german, scandinavian language(s) - i.e. european characters, quite non-ascii.

however, query column using ascii characters - e.g. in clause- ă,î,â,ș,ț,ü,ä,ö etc. characters can (succesfully) queried using a,e,i,o,u,s,t etc.

is possible ?

there cheat sheet knowing letters map "equal" under collations in utf8 collations agrees Ł not mapped l collation. general_ci sorts after z; utf8_unicode_520_ci sorts l; rest sort before m.

polish_ci treats Ę distinct rest of e-like characters. ditto Ą. baltic states tend keep accented consonants separate.

in polish_ci, Ń (hex c584) collates after n , before o; other collations treate equal n.

utf8_unicode_520_ci best collation you.

also, might consider "combining" accents -- 2 utf8 'characters' "combine" make single characters. utf8_unicode_ci collates 'correctly' of them, seen here.


Comments

Post a Comment

Popular posts from this blog

IF statement in MySQL trigger -

this query code in mysql trigger. if 1=2 select 'yes'; else select 'no'; end if; but has following error: if '1'='2' select 'yes' error code: 1064. have error in sql syntax; check manual corresponds mysql server version right syntax use near 'if '1'='2' select 'yes'' @ line 1 0.000 sec what solution?
Read more

c++ - What does MSC in "// appease MSC" comments mean? -

i run across // appease msc in c++ comments, e.g. here : const int& array::operator[](int offset) const { int mysize = getitssize(); if (offset >= 0 && offset < getitssize()) return ptype[offset]; throw xboundary(); return ptype[offset]; // appease msc! } what msc stand ? the author means microsoft's compiler, more formally known msvc.
Read more

android - MPAndroidChart - How to add Annotations or images to the chart -

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more