https://www.sqlite.org/pragma.html#pragma_pragma_list
A pragma can take either zero or one argument. The argument is may be either in parentheses or it may be separated from the pragma name by an equal sign. The two syntaxes yield identical results. In many pragmas, the argument is a boolean. The boolean can be one of: *1 yes true on0 no false off* Keyword arguments can optionally appear in quotes. (Example: 'yes' [FALSE].) Some pragmas takes a string literal as their argument. When pragma takes a keyword argument, it will usually also take a numeric equivalent as well. For example, "0" and "no" mean the same thing, as does "1" and "yes". When querying the value of a setting, many pragmas return the number rather than the keyword. looks like , from the docs, ` pragma *case_sensitive_like` should rteturn the value; a pragma without a value. there's also a pragma pragma_list which (if compiled in) will return all available pragmas 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
