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