Re: [sqlite] Select ignoring accents

2006-10-12 Thread Dennis Cote
Marco Bambini wrote: I need to find out a way to search all the records inside an sqlite database ignoring accents and case. So for example with a "select" I would like to find: Aero àero Aéro Ignoring case is the easy part, what about accents? Marco, You will need to create your own collat

[sqlite] Select ignoring accents

2006-10-12 Thread Marco Bambini
I need to find out a way to search all the records inside an sqlite database ignoring accents and case. So for example with a "select" I would like to find: Aero àero Aéro Ignoring case is the easy part, what about accents? Thanks a lot for your help. --- Marco Bambini -