Hi,
I want to do a search on varchar with accents. Actually if I type “Sedation” the application return nothing or I have record with the name “Sedaction” (with accent)
Could I do a search whitout accent sensitive?
Regards,
If you construct your own SQL search query you can do this kind of thing. Look in the PostgreSQL text functions to see if there is a way of stripping the accents.
to_ascii()
sounds promising.
You can take it a lot further than just ignoring accents, We are searching for similar names in PostgreSQL using dmetaphone()
SELECT person_id FROM people WHERE dmetaphone(person_name) = dmetaphone(?)
Ok I’ll try to construct my own SQL search query so.
Thanks
How do you know I use postgres?
Because you asked some PostgreSQL question a few days ago 
Do you use the installer from Marc at www.entropy.ch?
Which installer?
I don’t know www.entropy.ch
But if you want goodies like fuzzystringmatch on Mac OS X you still need to compile from source. A scary thought at first, but not really that difficult…