How to properly configure sqlite so that LIKE works in Cyrillic?

Question

PHP

Hello. Tell me, please, how to set it up correctly so that LIKE works in Cyrillic?
I am using sqlite3 in express.js project

CREATE TABLE people (
  pbnum INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  pbfirstName VARCHAR(50) NOT NULL,
  pblastName VARCHAR(50) NOT NULL,
  pbcity VARCHAR(50) NOT NULL,
  pbphoneNumber VARCHAR(50) NOT NULL);


INSERT INTO people (pbfirstName, pblastName, pbcity, pbphoneNumber) VALUES
('user', 'one', 'Сочи', '[phone]'),
('user', 'two', 'Москва', '[phone]'),
('user', 'three', 'Москва', '[phone]'),
('user', 'four', 'Москва', '[phone]'),
('user', 'five', 'Москва', '[phone]');


SELECT * FROM people WHERE CONCAT (pbfirstName, pblastName, pbcity) LIKE "%со%"

'Sochi' in this case does not fall into the sample.

Answer 1

It did not work due to the fact that the ssl certificate was not connected.

Answer 2

What do the logs say?

Answer 3

Check $txt - everything that goes into $api (for a link) should already be in the URL
To check, try entering "%D0%9F%D1%80%D0%B8%D0%B2%D0%B5%D1%82" instead of "$txt"
Or drop the full $api link for an example.

Answer 4

This is a well-known bug feature of sqlite. Do like this:
Cast both parts to the same case, then LIKE works. And since you still have a wildcard on both sides, you can still forget about using indexes, so it doesn’t change anything.
If the wildcard was only on one side, it would be possible to create a functional index