[web2py] Re: upper with Cyrillic

I use sqlite, but it turned out that sqlite not work functions Upper and Lover with Cyrillic In postgres Upper, Lover working correctly понедельник, 24 ноября 2014 г., 1:04:43 UTC+7 пользователь Massimo Di Pierro написал: > > Good question. No idea. left left hand side asked the database to perf

[web2py] Re: upper with Cyrillic

Good question. No idea. left left hand side asked the database to perform capitalization in unicode. The right hand side does it in python. There is no guarante they will use the same rules for cyrillic. You can try: db.wanted.fam.upper()==fam.decode('utf8').upper().encode('utf8') but I cannot