Re: [sqlite] collation for german "Umlaute"

2013-10-31 Thread Jean-Christophe Deschamps
Search the Internet for an SQLite extension called "unifuzz.c" and see if that does what you want in the way of character folding. I have a copy of the code on my other computer if you cannot find the original authors original code. Here is the download link: https://dl.dropboxusercontent.com

Re: [sqlite] collation for german "Umlaute"

2013-10-30 Thread Keith Medcalf
Search the Internet for an SQLite extension called "unifuzz.c" and see if that does what you want in the way of character folding. I have a copy of the code on my other computer if you cannot find the original authors original code. I didn't write it, but it basically implements a NOCASE collati

Re: [sqlite] collation for german "Umlaute"

2013-10-30 Thread Igor Tandetnik
On 10/30/2013 8:51 AM, Ulrich Goebel wrote: I want to use such a collation even on columns which are indeces, so I would like to "connect" the collation to the column/index at the time creating the column/index, not only in the later SELECTs. And I suppose, that I really don't have to specify the

Re: [sqlite] collation for german "Umlaute"

2013-10-30 Thread Richard Hipp
On Wed, Oct 30, 2013 at 8:51 AM, Ulrich Goebel wrote: > Hallo, > > for a SQLite db I would like to define a collation for german "Umlaute" > (don't know the english word for that, sorry) and "Sonderzeichen" (äöü, > ÄÖÜ, ß), so that: > > a=A=ä=Ä > o=O=ö=Ö > u=U=ü=Ü > ß=s (or, better: ß=ss) > > I w

[sqlite] collation for german "Umlaute"

2013-10-30 Thread Ulrich Goebel
Hallo, for a SQLite db I would like to define a collation for german "Umlaute" (don't know the english word for that, sorry) and "Sonderzeichen" (äöü, ÄÖÜ, ß), so that: a=A=ä=Ä o=O=ö=Ö u=U=ü=Ü ß=s (or, better: ß=ss) I want to use such a collation even on columns which are indeces, so I woul