I works with python 2.5 on windows,  And I use sqlite3

Now, I have problem searching string in Hebrew in my database

I have table called "test" with field num and test
firs row i insert  "1" and "עברית"  (that is "Hebrew" in Hebrew)
second row i insert "2" and "English"

now this code will print me
>>> English
as it should:

i="Englisht"
cur.execute("select *  from `test` where text like '%"+i+"%'  ")
for row in cur:
    print row[1]

but this one print me nothing
>>>
instead of עברית

i="עברית"
cur.execute("select *  from `test` where text like '%"+i+"%'  ")
for row in cur:
    print row[1]

does any one have an idea how can i solve it?
--
http://mail.python.org/mailman/listinfo/python-list

Reply via email to