Home » U++ Library support » U++ SQL » [SQLITE] Search accents insensitive (How to select records without sensivity to the case and accents ?)
| Re: [SQLITE] Search accents insensitive [message #48267 is a reply to message #48198] |
Tue, 13 June 2017 12:32   |
|
|
Instead of additional column, you can use a user defined function:search * from some_table where normalize(name) like '%jeremy%';
You'd of course need to call the same normalization function on the input as well.
This would give you a workaround around the problems with LIKE, without adding more data to your database (for the price of some CPU cycles  ). But you'll still need to write the code to strip the accents. I think that Mireks work on unicode decomposition might help with that a lot.
Best regards,
Honza
[Updated on: Tue, 13 June 2017 12:33] Report message to a moderator |
|
|
|
Current Time: Mon Jul 07 11:55:49 CEST 2025
Total time taken to generate the page: 0.07000 seconds
|
Members
Pages
Help
Register
Login
Home
