Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Search query problem with russian symbols #845

Open
Zokirjon-Ashiraliyev opened this issue Oct 18, 2024 · 0 comments
Open

Search query problem with russian symbols #845

Zokirjon-Ashiraliyev opened this issue Oct 18, 2024 · 0 comments

Comments

@Zokirjon-Ashiraliyev
Copy link

Zokirjon-Ashiraliyev commented Oct 18, 2024

@query(
'''SELECT client.*, GROUP_CONCAT(client_visit_date.day) AS visit_dates
FROM client
LEFT JOIN client_visit_date ON client.client_id = client_visit_date.client_id
WHERE client.name LIKE :query COLLATE NOCASE
GROUP BY client.client_id''',
)
Stream<List> observeGetSearchClientByName(String query);
I use this method in dao class, but i had problem with russian symbols.

Stream<List<Client>> observeGetAllClientListSearchByName(String query) {
log("ClientRepositoryResultBefore->$query");
final searchQuery = '%${query}%';
log("ClientRepositoryResult->$searchQuery");
return clientDao
    .observeGetSearchClientByName(searchQuery)
    .asyncMap((event) => event.map((e) => e.toClient()).toList());

}

this my method which call observeGetSearchClientByName in other classes. For example I start to search word such as Па, this word find successfully, but when i search па word it does not find. I applied various solution for fixing this problem, For example i wrapped name and query but it does not find. How can fix it . This code only does not work in iphone, android phones work correct query only iphone have problem
.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

1 participant