On Wed, Aug 14, 2013 at 1:59 PM, Dominique Devienne <[email protected]>wrote:
>
> Not authoritative of course, but Oracle seems to agree with the previous
> behavior. --DD
>
Dominique, can you please try the following SQL on Oracle and let me know
what you get:
CREATE TABLE t1(m VARCHAR(4));
INSERT INTO t1 VALUES('az');
INSERT INTO t1 VALUES('by');
INSERT INTO t1 VALUES('cx');
SELECT '1', substr(m,2) AS m
FROM t1
ORDER BY m;
SELECT '2', substr(m,2) AS m
FROM t1
ORDER BY lower(m);
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
