StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>It seems that SQLite does not care about locale at all. The only place I found a mentioning about locales is computation of <code>datetime('now')</code>. But the documentation says that its behavior depends on the underlying C functions. It does store text data in unicode by default (in versions above 3.0), but the conversion to unicode is the responsibility of the client libraries.</p> <p>By the way, SQLite console under MS Windows is one of those rare console applications that still works as expected when you switch the console codepage to utf-8.</p> <p><strong>UPD</strong>:</p> <p>Some citations from SQLite cocumentation:</p> <p><a href="http://www.sqlite.org/datatype3.html#collation" rel="nofollow noreferrer">one</a>:</p> <blockquote> <p>When SQLite compares two strings, it uses a collating sequence or collating function (two words for the same thing) to determine which string is greater or if the two strings are equal. SQLite has three built-in collating functions: BINARY, NOCASE, and RTRIM.</p> <ul> <li>BINARY - Compares string data using memcmp(), regardless of text encoding.</li> <li>NOCASE - The same as binary, except the 26 upper case characters of ASCII are folded to their lower case equivalents before the comparison is performed. Note that only ASCII characters are case folded. SQLite does not attempt to do full UTF case folding due to the size of the tables required.</li> <li>RTRIM - The same as binary, except that trailing space characters are ignored.</li> </ul> <p>An application can register additional collating functions using the sqlite3_create_collation() interface.</p> </blockquote> <p><a href="http://www.sqlite.org/lang_corefunc.html" rel="nofollow noreferrer">two</a>:</p> <blockquote> <p><strong>lower(X)</strong> The lower(X) function returns a copy of string X with all ASCII characters converted to lower case. The default built-in lower() function works for ASCII characters only. To do case conversions on non-ASCII characters, load the ICU extension.</p> <p><strong>upper(X)</strong> The upper(X) function returns a copy of input string X in which all lower-case ASCII characters are converted to their upper-case equivalent.</p> </blockquote> <p><a href="http://www.sqlite.org/compile.html#enable_icu" rel="nofollow noreferrer">three</a>:</p> <blockquote> <p><strong>SQLITE_ENABLE_ICU</strong> This [compilation] option causes the <a href="http://www.icu-project.org/" rel="nofollow noreferrer">International Components for Unicode</a> or "ICU" extension to SQLite to be added to the build. </p> </blockquote> <hr> <p>Seems like in either way you will need to compile the sqlite yourself.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload