Hello, This is probably a very basic question but I'm having a problem writing queries that should be accent insensitive. I have pg v8.1 for Windows installed with Portuguese support and everything works fine except a very basic thing. An example query like the following: select name from clients where name like '%Jose%' should return all names including Jose or Jose' (or any other accent variation) because they are equivalent but I'm getting from pg only the ones I specifically include in the query expression. We have lots of expressions with equivalents like these and it is not possible to explicitly decompose a query in all possible variations. I've also verified that it sorts correctly ignoring accents and the problem is only in querying. I'm experienced with SQL Server (now learning pg) and there only by choosing the appropriate collation I get case/accent sensitivity policy well defined. Is there any similar parameter in pg that I've missed and have the same effect? Can anybody help me on this? Many thanks JLS
