Re: [sqlite] Collation not used

Igor Tandetnik wrote: > Martin Engelschalk > wrote: > >> The problem appeared when my users eliminated leading blanks from the >> data. >> > > I'm not sure I understand. What does this have to do with collating > numbers? Are you saying you were storing

Re: [sqlite] Collation not used

Martin Engelschalk wrote: > The problem appeared when my users eliminated leading blanks from the > data. I'm not sure I understand. What does this have to do with collating numbers? Are you saying you were storing numbers as strings, with leading blanks, and had a

Re: [sqlite] Collation not used

Hello Igor, in the beginning this was an attempt to circumvent the missing DESC Indices prior to Version 3.3.0. However, it all grew and now i do all kinds of things using collations. I admit that i could achieve most of them in a different way, but i would have to change my application. The

Re: [sqlite] Collation not used

Martin.Engelschalk wrote: > yes, you are right, Thank you. > Is there a reason for this? Why would you want a collation function for numbers? What are you trying to achieve? Igor Tandetnik ___ sqlite-users mailing list

Re: [sqlite] Collation not used

Hello Dan, yes, you are right, Thank you. Is there a reason for this? martin Dan schrieb: > On Jan 9, 2009, at 9:43 PM, Martin.Engelschalk wrote: > > >> Hello list, >> >> I definied a collation and used it in the order by - clauses of >> queries. >> In one query, sqlite calls the collation

Re: [sqlite] Collation not used

On Jan 9, 2009, at 9:43 PM, Martin.Engelschalk wrote: > Hello list, > > I definied a collation and used it in the order by - clauses of > queries. > In one query, sqlite calls the collation function, and in the other > query, it does not (i checked by inserting a printf inside the >

[sqlite] Collation not used

Hello list, I definied a collation and used it in the order by - clauses of queries. In one query, sqlite calls the collation function, and in the other query, it does not (i checked by inserting a printf inside the collation function). The queries differ only in the order by - clause. This