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: Sat Apr 27 19:15:38 CEST 2024
Total time taken to generate the page: 0.07265 seconds
|
Members
Pages
Help
Register
Login
Home
