U++ framework: U++ SQL » [SQLITE] Search accents insensitive

Home » U++ Library support » U++ SQL » [SQLITE] Search accents insensitive (How to select records without sensivity to the case and accents ?)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

[SQLITE] Search accents insensitive [message #48198]

Thu, 01 June 2017 15:25

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 !

Report message to a moderator

[Message index]

		[SQLITE] Search accents insensitive By: jibe on Thu, 01 June 2017 15:25
		Re: [SQLITE] Search accents insensitive By: koldo on Tue, 13 June 2017 10:16
		Re: [SQLITE] Search accents insensitive By: jibe on Tue, 13 June 2017 11:31
		Re: [SQLITE] Search accents insensitive By: dolik.rce on Tue, 13 June 2017 12:32
		Re: [SQLITE] Search accents insensitive By: jibe on Fri, 16 June 2017 11:40
		Re: [SQLITE] Search accents insensitive By: deep on Sat, 17 June 2017 15:39
		Re: [SQLITE] Search accents insensitive By: dolik.rce on Mon, 19 June 2017 21:02
		Re: [SQLITE] Search accents insensitive By: jibe on Mon, 19 June 2017 22:36
		Re: [SQLITE] Search accents insensitive By: jibe on Thu, 29 June 2017 15:11
		Re: [SQLITE] Search accents insensitive By: jibe on Fri, 30 June 2017 11:12

Previous Topic:	Please Help Me
Next Topic:	How SQL deal with multiple threads?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Oct 31 07:41:11 GMT+1 2026

Total time taken to generate the page: 0.20962 seconds