News for hackers. Stuff that matters.

A comment on Appropriate Uses for SQLite. Parent comment

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 ]