Back

search does not work with words where 1 or 2 letters

  • 0
  • Self Hosted
  • Databases
polbuhanky
31 Aug, 2023, 12:11
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.
polbuhanky
31 Aug, 2023, 12:20

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

Drake
31 Aug, 2023, 19:53

search does not work with words where 1 or 2 letters

Drake
31 Aug, 2023, 19:55

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

polbuhanky
3 Sep, 2023, 18:48

Understand, but how can I change this param innodb_ft_min_token_size?

Drake
3 Sep, 2023, 18:53

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.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more