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

Re: [SQLITE] Search accents insensitive [message #48262 is a reply to message #48198]

Tue, 13 June 2017 10:16

koldo
Messages: 3460
Registered: August 2008

Senior Veteran

jibe wrote on Thu, 01 June 2017 15:25

A workaround would be to duplicate the column and fill the second with upper case text without accent, but it is not very elegant !

Hello Jibe

That is what I do. There is a function in Functions4U to remove accents and I duplicate the field with the data without accents. After that I use that field for searching.

Best regards
Iñaki

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: Thu Jun 18 00:57:14 GMT+2 2026

Total time taken to generate the page: 0.00551 seconds