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: Sun Apr 26 01:26:28 GMT+2 2026
Total time taken to generate the page: 0.00482 seconds
|
U++ framework
Search
Help
Members
Register
Login
Home
