Search Postgresql Archives

Re: Help on collation and accent sensitivity

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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, but I'm not sure how that works 
on Windows.

Rumour has it that some people to accent-insensitive comparisons using 
the to_ascii function.  Since the notion of accent-sensitivity differs 
between languages, it'd probably be best if you wrote your own 
conversion function.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux