Re: convert sqlite ANSI to UTF-8

2008-06-11 Thread Mike Driscoll
On Jun 11, 10:04 am, Gandalf <[EMAIL PROTECTED]> wrote: > I used sqliteadmin to manage my sqlite database and I copy past > queries translated from mysql phpmyadmin output it worked (little > slowly but worked...), the only problem now is that sqliteadmin stored > my hebrew char as ANSI instead of

convert sqlite ANSI to UTF-8

2008-06-11 Thread Gandalf
I used sqliteadmin to manage my sqlite database and I copy past queries translated from mysql phpmyadmin output it worked (little slowly but worked...), the only problem now is that sqliteadmin stored my hebrew char as ANSI instead of UTF-8 and now I don't know how to search data from this table.