Case insensitive sorting of string without using lower or upper funciton

SQL++
,
1

Hi,

I was wondering if it is possible to provide case-insensitive sorting without using lower() or upper()
in order by clause in N1QL.

2

Order always follows collation order. There is no way to change that.

3

@vsr1 I’m not sure what it means. Can you please rephrase it?

4

Sorry there is typo I mean to say there is no way to change that without using those functions.

Checkout Collation in the following page.

https://developer.couchbase.com/documentation/server/current/n1ql/n1ql-language-reference/datatypes.html

5

Thanks for your response.

6

@vsr1, One more question… Why Unicode collation is being used in map reduce views while N1QL is using byte order? I mean why not keep both the same?

7

Also, please confirm if there is any setting available or not for changing the N1QL collation to Unicode.

8

Unicode collation is expensive, that is reason N1QL using byte order. N1QL doesn’t allow changing the collation.