On Wed, Aug 14, 2013 at 8:42 PM, Dominique Devienne <ddevie...@gmail.com>wrote:
> On Wed, Aug 14, 2013 at 8:03 PM, Richard Hipp <d...@sqlite.org> wrote:
>
>> On Wed, Aug 14, 2013 at 1:59 PM, Dominique Devienne <ddevie...@gmail.com
>> >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:
>>
>
> Sure, no problem:
>
> SQL> CREATE TABLE t1(m VARCHAR(4));
>
> Table created.
>
> SQL> INSERT INTO t1 VALUES('az');
>
> 1 row created.
>
> SQL> INSERT INTO t1 VALUES('by');
>
> 1 row created.
>
> SQL> INSERT INTO t1 VALUES('cx');
>
> 1 row created.
>
> SQL> SELECT '1', substr(m,2) AS m
> 2 FROM t1
> 3 ORDER BY m;
>
> ' M
> - ------------
> 1 x
> 1 y
> 1 z
>
> SQL> SELECT '2', substr(m,2) AS m
> 2 FROM t1
> 3 ORDER BY lower(m);
>
> ' M
> - ------------
> 2 x
> 2 y
> 2 z
>
Oracle 11gR2 didn't like the COLLATE query:
SQL> SELECT '3', substr(m,2) AS m
2 FROM t1
3 ORDER BY m COLLATE Latin1_General_CS_AS;
ORDER BY m COLLATE Latin1_General_CS_AS
*
ERROR at line 3:
ORA-00933: SQL command not properly ended
Not sure the below will be useful, I just quickly googled what may be the
equivalent:
SQL> SELECT '3', substr(m,2) AS m
2 FROM t1
3 ORDER BY NLSSORT(m, 'NLS_SORT=german');
' M
- ------------
3 x
3 y
3 z
SQL> ALTER SESSION SET NLS_SORT=german;
Session altered.
SQL> SELECT '3', substr(m,2) AS m
2 FROM t1
3 ORDER BY m;
' M
- ------------
3 x
3 y
3 z
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
