Back
Query equal by Vietnamese characters
Hi, I'm trying to get list of documents by Query.equal(). My data is saved with Vietnamese characters format, something like "trường đại học", but user usually uses "truong dai hoc" only. In this case, I can't get any document. Is there anyway to do it without create an extra attribute to store English character?
Update 1: I found that it doesn't work with "đ" if I use "d", others are fine.
TL;DR
Appwrite uses MariaDB search and there might be a bug with Vietnamese characters. You can report the issue on their GitHub. The developer is trying to get a list of documents with Vietnamese characters but is unable to do so with Query.equal(). They found that it doesn't work with the character "đ" if they use "d". One possible solution could be to create an extra attribute to store English characters.
I think appwrite uses MariaDB search, so if it's unexpected because it works except for the d character it could be a bug there. You could report it in their GitHub
