search does not work with words where 1 or 2 letters - Threads - Appwrite

Skip to content

TL;DR

The user is experiencing an issue with the search function not working with words containing 1 or 2 letters. They suggest running a SQL command to fix it. Another user suggests changing the 'innodb_ft_min_token_size' parameter, with a link to more information. The solution would be to adjust the 'innodb_ft_min_token_size' parameter as mentioned in the provided link.

I noticed that the search does not work with words where 1 or 2 letters. How to fix it?

search does not work with words where 1 or 2 letters

Right, that's how mariadb's full text search works. For more info see: https://github.com/appwrite/appwrite/discussions/5005#discussioncomment-4681079.

The only way to change this would be to change this: https://mariadb.com/kb/en/innodb-system-variables/#innodb_ft_max_token_size

Understand, but how can I change this param innodb_ft_min_token_size?

I think by running a SQL command. You can look it up online

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Get premium support

Join Appwrite Pro and get email support from our team.