Re: [sqlite] SQLite sorting/searching algorithm

2014-03-25 Thread Gerry Snyder
Look at COLLATE in the ORDER BY clause. Gerry On Mar 25, 2014 11:32 AM, "michal.pilszak" wrote: > "you cannot tell SQLite to use a particular algorithm to do those things" > that's exactly what I wanted to know. So, I won't waste my time on looking > for impossible on

Re: [sqlite] SQLite sorting/searching algorithm

2014-03-25 Thread michal . pilszak
"you cannot tell SQLite to use a particular algorithm to do those things" that's exactly what I wanted to know. So, I won't waste my time on looking for impossible on Internet. Thank you for this answear. And thank you for suggestion with ANALYZE command. This maybe be useful. I'll try to get

Re: [sqlite] SQLite sorting/searching algorithm

2014-03-25 Thread Simon Slavin
On 25 Mar 2014, at 5:48pm, michal.pilszak wrote: > Is there any parameter I can set to select another algorithm (e.g. another > algorithm of ORDER BY) and check its efficiency? You can tell SQLite to search for different rows or order them in a different order. But you

Re: [sqlite] SQLite sorting/searching algorithm

2014-03-25 Thread michal . pilszak
I see my second question is not constructed well. I forgot one word at the end of phrase. Let me repeat: 2. Secondly, I'm using SQLite in my Android app, and I was wondering is there any (easy) way to select a different type of sorting or searching ALGORITHM? I know there are "ORDER BY"

Re: [sqlite] SQLite sorting/searching algorithm

2014-03-25 Thread Simon Slavin
On 25 Mar 2014, at 4:02pm, michal.pilszak wrote: > Hello, I've got a few questions: 1. Firstly, I was wondering what are the > types of sorting and searching algorithms used in SQLite?2. Secondly, I'm > using SQLite in my Android app, and I was wondering is there any

[sqlite] SQLite sorting/searching algorithm

2014-03-25 Thread michal . pilszak
Hello, I've got a few questions: 1. Firstly, I was wondering what are the types of sorting and searching algorithms used in SQLite?2. Secondly, I'm using SQLite in my Android app, and I was wondering is there any (easy) way to select a different type of sorting or searching? -- Greets, MP.

[sqlite] SQLite - sorting and case-insensitive comparison of Unicode characters

2010-12-07 Thread Vladimir Ljepoja
Hi Guys, SQLite has problems related to the sorting and case-insensitive comparison of Unicode characters. It solved this problem by enabling ICU extension. But, I couldn't find detailed information about its enabling within "ADO.NET 2.0 Provider for SQLite" (http://sqlite.phxsoftware.com/). I

Re: [sqlite] SQLITE: sorting

2010-10-12 Thread Jean-Christophe Deschamps
Look in your mailbox. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLITE: sorting

2010-10-12 Thread Uy, Mary
Hi, I saw this in the forum: I've developped an SQLite extension including a very similar collation: it sorts the (integral) prefix first and, in case of a draw, orders based on the Unicode suffix. It currently doesn't cope with floating-point prefixes but can surely be adapted easily to do so.