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 #48297 is a reply to message #48198] |
Fri, 16 June 2017 11:40 |
|
jibe
Messages: 294 Registered: February 2007 Location: France
|
Experienced Member |
|
|
Hi, Honza,
Thanks for your reply, but did you noticed well that I am working with SQLITE and that I mentioned
Quote:But as far as I know, with SQLITE, we have to create a special collation function, which does not works with LIKE, so we have also to create a special LIKE function.
Is it what you mean when you say
Quote:But you'll still need to write the code to strip the accents.
My problem is that I don't know exactly what to do, how to write this special collation function inside the SQLITE code and how to modify the LIKE funtion to use it...
As I think that this problem is frequent and has probably already been solved by somebody, my question was more especially about an already existing solution for SQLITE...
I forgot to say : trying your code, Honza, I got the error "no such function: normalize"
[Updated on: Fri, 16 June 2017 11:57] Report message to a moderator
|
|
|
Goto Forum:
Current Time: Sun Apr 28 15:22:36 CEST 2024
Total time taken to generate the page: 0.01594 seconds
|