Re: [sqlite] Will collate binary supports like query

2014-09-30 Thread dd
Thank you :-) On Tue, Sep 30, 2014 at 3:44 PM, Simon Slavin wrote: > > On 30 Sep 2014, at 12:32pm, dd wrote: > > > My db already there in production. I have to do it programmatically. > > > > Can it be done with any sqlite apis/pragmas. > > Sure. But you do need to drop the table at one point

Re: [sqlite] Will collate binary supports like query

2014-09-30 Thread Simon Slavin
On 30 Sep 2014, at 12:32pm, dd wrote: > My db already there in production. I have to do it programmatically. > > Can it be done with any sqlite apis/pragmas. Sure. But you do need to drop the table at one point so nothing should be trying to use it. Depending on how your indexes, triggers a

Re: [sqlite] Will collate binary supports like query

2014-09-30 Thread dd
My db already there in production. I have to do it programmatically. Can it be done with any sqlite apis/pragmas. On Tue, Sep 30, 2014 at 3:19 PM, Simon Slavin wrote: > > On 30 Sep 2014, at 12:07pm, dd wrote: > > > Hi Simon, > > > >>> However, frequent use of COLLATE often suggests that the or

Re: [sqlite] Will collate binary supports like query

2014-09-30 Thread Simon Slavin
On 30 Sep 2014, at 12:07pm, dd wrote: > Hi Simon, > >>> However, frequent use of COLLATE often suggests that the original schema > was badly chosen. > Any performance degradation? Having SQLite analyse the command, work out what 'COLLATE BINARY' means, and making the change means that it

Re: [sqlite] Will collate binary supports like query

2014-09-30 Thread dd
Hi Simon, >>However, frequent use of COLLATE often suggests that the original schema was badly chosen. Any performance degradation? Is it possible to change "collate nocase" to "collate binary" in schema for already existing db? Any alternative solution for this? Thanks. On Tue, Sep 30, 2

Re: [sqlite] Will collate binary supports like query

2014-09-30 Thread Simon Slavin
On 30 Sep 2014, at 7:03am, dd wrote: > Needs to support case-sensitive for case-insensitive sqlite > database field . To find exact case, COLLATE BINARY, works very well. > > > > What is the work around for like queries. Needs to case-sensitive for > like queries

Re: [sqlite] Will collate binary supports like query

2014-09-30 Thread dd
@RSmith, yes. nice. Is it possible to change "collate nocase" to "collate binary" in schema for already existing db? On Tue, Sep 30, 2014 at 1:44 PM, RSmith wrote: > > On 2014/09/30 09:03, dd wrote: > >> I just got below pragma: >> pragma case_sensitive_like = true >> >> As an aside... The

Re: [sqlite] Will collate binary supports like query

2014-09-30 Thread RSmith
On 2014/09/30 09:03, dd wrote: I just got below pragma: pragma case_sensitive_like = true As an aside... The beauty of it being a Pragma is that you are not stuck with a single method - you can switch it on and off at a whim... Maybe even provide a GUI interface to switch modes. _

Re: [sqlite] Will collate binary supports like query

2014-09-30 Thread dd
I just got below pragma: pragma case_sensitive_like = true On Tue, Sep 30, 2014 at 10:03 AM, dd wrote: > Hi, > > Needs to support case-sensitive for case-insensitive sqlite > database field . To find exact case, COLLATE BINARY, works very well. > > > > What is the work around for like

[sqlite] Will collate binary supports like query

2014-09-29 Thread dd
Hi, Needs to support case-sensitive for case-insensitive sqlite database field . To find exact case, COLLATE BINARY, works very well. What is the work around for like queries. Needs to case-sensitive for like queries and lessthan, greaterthan operators. OR Is there anyway to change