I want to search for "josé", and i want that typing "josé" or "jose" the result to be the same, this is using POSTGRESQL. How do i do that?
just edit what the person puts in.
Use str_replace() to go from 'é' to 'e' ,etc. This is a pretty sloppy way of doing it, but I can't think of anything better.
select * from table where name like 'jos%'
it will include jos?, jose, joses......
any better idea?
