Case insensitive sorting of string without using lower or upper funciton

query
n1ql

#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.