SQlite none english char
Gandalf
goldnery at gmail.com
Sat Jun 7 20:08:23 EDT 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