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
-~----------~----~----~----~------~----~------~--~---
