U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

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 :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

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

Mon, 19 June 2017 22:36

jibe is currently offline

jibe
Messages: 294
Registered: February 2007
Location: France

Experienced Member

Hi Honza,

Thanks for your help Smile

Smile

All my database is UTF8... So, effectively, it will not be so easy. I'll see if I can wait that Mirek finishes, or I'll do as Koldo : another column... But before, I'll also see if I can use Koldo's function to remove the accents in association with a sqlite3_create_function()...

@deep :

Thanks for your reply, but in my case it will not be very easy, because the code is to allow users to create their own requests. So, I should probably be obliged to automatically generate a regexp each time... And as sqlite doesn't support regexp, I'll also have to extend it with this support... And as says Honza, this depends also what encoding is used...

Report message to a moderator

Send a private message to this user

[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:	Oracle 12c

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sun Apr 28 12:30:30 CEST 2024

Total time taken to generate the page: 0.04365 seconds