Filter with $containsi(not case-sensitive) parameter, doesn't work with cyrillic

Questions and Answers
1
System Information
  • **Strapi Version4.5.5:
  • **Operating SystemUbuntu 20.04:
  • **Databasebetter-sqlite3": "7.4.6:
  • **Node Version16.8.0:
  • **NPM Version7.24.2:
  • Yarn Version:

In database i got ingredient with name “Чикен хит”
Request - “/api/ingredients?sort[0]=nameru:asc&pagination[pageSize]=24&pagination[page]=1&populate=&filters[nameru][$containsi]=чик" - does not give me this ingredient, while request - "/api/ingredients?sort[0]=nameru:asc&pagination[pageSize]=24&pagination[page]=1&populate=&filters[nameru][$containsi]=Чик” does.
Filtering with latin symbols work fine.
Please, help

2 Likes
2

the same problem. did you solve it?

3

Same problem, how to solve it?

4

Looks like the problem is because of sqlite3 by default cannot compare characters that are not in ASCII

You are need to use extended sqlite3 (ft3/ft4) that has such feature

5

I have build from source with enabled fts3/fts4/fts5 and it is not working