Skip to content
Start project
Back

Query equal by Vietnamese characters

  • 0
  • Databases
View on Discord
HuynhThien
1 Jan, 2025, 17:02

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.
D5
1 Jan, 2025, 17:10

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

HuynhThien
1 Jan, 2025, 17:15
Reply

Reply to this thread by joining our Discord

Reply on Discord

Recommended threads

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more