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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
