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
"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
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
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"
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
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.
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
Look in your mailbox.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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.
9 matches
Mail list logo