I have been searching a lot for how to compare strings in a n1ql query.
I am using Couchbase 6.5 currently but when i started to check the buckets it looks like this never worked for me. My guess is that the issue is with (from the documentation):
“String comparison is done using a raw-byte collation of UTF-8 encoded strings (sometimes referred to as binary, C, or memcmp). This collation is case sensitive”
select meta().id, username from userdata where username = “David” -> This works fine since no Swedish characters
select meta().id, username from userdata where username = “Åke” -> The documents that has usename = “Åke” will not be found.
I am not sure how to get around this - if i should change the encoding of the string from python to make this work or make the search in n1ql in another way.
I am using the python SDK for my application and python version 3.7