I do not know. The same version that comes with python 2.5. Massimo
On Jan 2, 9:35 am, Petros Diveris <[email protected]> wrote: > Hi > > Thanks for the quick reply. I was rather surprised to read on the > supplied link, I always assumed that sqlite would handle utf-8 upper / > lower case. What version is the sqlite bundled with web2py 1.54 > windows? > > Cheers > > Petros Diveris > > On Jan 2, 1:27 pm, mdipierro <[email protected]> wrote: > > > This > > >http://www.sqlite.org/lang_expr.html > > > says: > > > "A bug: SQLite only understands upper/lower case for 7-bit Latin > > characters. Hence the LIKE operator is case sensitive for 8-bit > > iso8859 characters or UTF-8 characters. For example, the expression > > 'a' LIKE 'A' is TRUE but 'æ' LIKE 'Æ' is FALSE." > > > perhaps it is possible to redefine upper using stored procedures... > > but Python itself does not seem to support this either: > > > >>> a="\303\206" > > >>> print a > > Æ > > >>> print a.lower() > > > Æ > > > If anybody has any suggestion I would like to know. If there is a > > workaround in Python, we can use sqlite3_create_function. > > > Massimo > > > On Jan 2, 5:01 am, Petros Diveris <[email protected]> wrote: > > > > Hi everyone and happy neww year! > > > > I have come across a very strange problem where I am trying to select > > > from an sqlite table with > > > > db.babel.definition.upper().like("'%"+me.word.upper()+"%'") ) which > > > yields nothing. > > > > The same happens if I try using sqlite's upper function > > > > db.babel.definition.upper().like("upper('%"+me.word+"%')") ) > > > > which also yields nothing. The text I am trying to select is Greek - > > > it all works fine with English > > > > The same sql statements work fine (they return rows) from native > > > sqlite clients (I haven't tried as yet from command line python.) Not > > > only it works fine with the native client, it even handles accented > > > characters etc. Same with German and umlauts... > > > > Has anybody seen anything like this with international text? > > > > I have even tried this so to avoid handling the keyword in Python > > > > rows=db("upper(definition) like '%' || upper((select word from > > > babel where id="+str(me.id)+")) || '%'").select(db.babel.ALL) > > > > assuming that something happens on the python side. One would expect > > > this to work since the whole string comparison should happen on the > > > sqlite side. It still doesn't handle uupper / lower case. Help! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
