Marcos E. Wurzius wrote:
Version 3 will implement Locale?
I do not know what you mean by "Locale".
Version 3 will support user-defined text collating functions.
You can register a new collating function (say "Portuguese").
The default collating sequence of a column can be specified
in CREATE TABLE statements. The collating sequence can be
overridden in an ORDER BY clause.
Examples:
CREATE TABLE t1(
x INTEGER PRIMARY KEY,
val TEXT COLLATE Portuguses
);
SELECT * FROM t2 ORDER BY val2 COLLATE Portuguese;
The default collating sequence is called "BINARY" and is
implemented by memcmp(). If you want a different collating
sequence, you'll have to add it yourself using the
sqlite3_create_collation() or sqlite3_create_collation16()
APIs. SQLite will not come with a prepackaged library of
collating functions.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
