Re: SQlite none english char

2008-06-09 Thread Gerhard Häring
Gandalf wrote: [...] I solved the problem by entering data manually but now the problem is that i had to delete this function: con.text_factory = str and now I can't see the data that I entered thought my sqlite manager Then apparently there is still non-UTF-8 data in the database. Perhaps SQ

Re: SQlite none english char

2008-06-08 Thread Gandalf
On Jun 8, 11:00 am, Gerhard Häring <[EMAIL PROTECTED]> wrote: > Gandalf wrote: > > 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 "עברי

Re: SQlite none english char

2008-06-08 Thread Gerhard Häring
Gandalf wrote: > 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 "Englis

SQlite none english char

2008-06-07 Thread Gandalf
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