Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » [SQLITE] Search accents insensitive (How to select records without sensivity to the case and accents ?)
[SQLITE] Search accents insensitive [message #48198] Thu, 01 June 2017 15:25 Go to previous message
jibe is currently offline  jibe
Messages: 294
Registered: February 2007
Location: France
Experienced Member
Hi,

I need to select records without sensivity to the case and accents : the SELECT query should return
Jeremy
Jérémy
JEREMY
JÉRÉMY
etc.

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.

Does somebody already created those functions ?

If not, I'm not very sure to be able to do that in U++ without (maybe a lot of) help... Any suggestion ?

A workaround would be to duplicate the column and fill the second with upper case text without accent, but it is not very elegant !
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Please Help Me
Next Topic: Oracle 12c
Goto Forum:
  


Current Time: Thu Mar 28 19:38:29 CET 2024

Total time taken to generate the page: 0.01153 seconds