SQlite none english char

Gandalf goldnery at gmail.com
Sun Jun 8 02:08:23 CEST 2008


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?



More information about the Python-list mailing list