Re: [sqlite] Diacritics (umlaut) select in SQLite

2008-07-21 Thread Michael Schlenker
Igor Tandetnik schrieb: > "Alexey Pechnikov" <[EMAIL PROTECTED]> wrote in > message news:[EMAIL PROTECTED] >> ? ? ?? Sunday 20 July 2008 21:20:19 Jay A. Kreibich >> ???(?): >>> The good news is that you can re-implement the LIKE function fairly >>> easily. There have been a number of

Re: [sqlite] Diacritics (umlaut) select in SQLite

2008-07-20 Thread Igor Tandetnik
"Alexey Pechnikov" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > ? ? ?? Sunday 20 July 2008 21:20:19 Jay A. Kreibich > ???(?): >> The good news is that you can re-implement the LIKE function fairly >> easily. There have been a number of posts in the past dealing with >>

Re: [sqlite] Diacritics (umlaut) select in SQLite

2008-07-20 Thread Alexey Pechnikov
В сообщении от Sunday 20 July 2008 23:39:34 Alexey Pechnikov написал(а): > >   The good news is that you can re-implement the LIKE function fairly > >   easily.  There have been a number of posts in the past dealing with > >   using external Unicode/I18N libraries to implement a more complete > >  

Re: [sqlite] Diacritics (umlaut) select in SQLite

2008-07-20 Thread Alexey Pechnikov
В сообщении от Sunday 20 July 2008 21:20:19 Jay A. Kreibich написал(а): >   The good news is that you can re-implement the LIKE function fairly >   easily.  There have been a number of posts in the past dealing with >   using external Unicode/I18N libraries to implement a more complete >   'LIKE'

Re: [sqlite] Diacritics (umlaut) select in SQLite

2008-07-20 Thread Jay A. Kreibich
On Sun, Jul 20, 2008 at 07:09:54PM +0200, william sqllite scratched on the wall: > Hi all, > > We're trying to get a big dictionary website running on SQLite (was MySQL), > but we ran into some trouble that we can't really seem to fix. > > While we're using UTF-8 coding, a query like > >

[sqlite] Diacritics (umlaut) select in SQLite

2008-07-20 Thread william sqllite
Hi all, We're trying to get a big dictionary website running on SQLite (was MySQL), but we ran into some trouble that we can't really seem to fix. While we're using UTF-8 coding, a query like SELECT * FROM language WHERE word like '%o%' doesn't find words with Ö or ö, while it did in MySQL.