https://www.sqlite.org/pragma.html#pragma_case_sensitive_like

Basically nope, there isn't a better way. There is no 0 argument version of the 
pragma, and there is no table-valued function as it's a pragma with a side 
effect. So running a small query where you know what the answer is is currently 
the only way.

Also means that if you're going to change it, you want to run that test query 
again afterwards to make sure it stuck. If there's a typo in your pragma call 
then it gets silently ignored, and there's no return value when setting it.


-----Original Message-----
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On 
Behalf Of J Decker
Sent: Thursday, August 16, 2018 10:16 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] PRAGMA case_sensitive_like


...


looks like , from the docs, `  pragma *case_sensitive_like` should rteturn
the value; a pragma without a value.


...

On Thu, Aug 16, 2018 at 6:16 AM Chris Locke <ch...@chrisjlocke.co.uk> wrote:

> While the pragma *case_sensitive_like *can be set, there doesn't seem to be
> a way to read it.
> Is there a reason for it being write only?
> A hacky workaround is to use the SQL, "select 'x' like 'X'  ", but is there
> a better way?
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to