Case insensitive sorting of string without using lower or upper funciton


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

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

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

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.

Thanks for your response.

@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?

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

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