Re: [GENERAL] Help on collation and accent sensitivity

2005-12-08 Thread Peter Eisentraut
jlmssilva wrote: > 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? You could try to define your own locale

[GENERAL] Help on collation and accent sensitivity

2005-12-07 Thread jlmssilva
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