News for hackers. Stuff that matters.

A comment on Appropriate Uses for SQLite. Parent comment

Re:Appropriate Uses for SQLite by Biganon on Monday September 26, 2016 @04:23AM (#12580154)
One of the reasons I don't use sqlite in my projects is the lack of an easy unaccent solution, to make queries that automatically suppress accents. All my projects are in French, and if you want to make a search function in French you absolutely need that. Almost nobody will search for "éléphant" with the accents, especially now that Google, Facebook etc. do not require it.
[ Parent | on HN ]
Re:Appropriate Uses for SQLite by majewsky on Monday September 26, 2016 @05:00AM (#12580320)
Does your programming language or framework not offer an unaccent (aka ASCII fold) function?
[ Parent | on HN ]
Re:Appropriate Uses for SQLite by elmigranto on Monday September 26, 2016 @06:05AM (#12580572)
I guess stored rows contain accents, not just query. So you run something along the lines of `unaccent(text) like unaccent(query)`; or, more realistically, you `create index on table(unaccent(text))`.
[ Parent | on HN ]
Re:Appropriate Uses for SQLite by majewsky on Monday September 26, 2016 @08:40AM (#12581282)
Oh I see. That makes sense.
[ Parent | on HN ]