On Wed, Feb 15, 2017 at 9:01 AM, Hari Sankar A
wrote:
> [...]
>
> I can use lower() and collate 'C' to get this result. But I need a default
> collate to support this.
>
> Is there any collation that support both (Case insensitive and special
> character) sorting in utf8?
>
>
> your help would
Hello All,
I am a Database administrator and we are using PostgreSQL-9.6.1 version in
RHEL-7 linux machine. Current server Encoding setup is UTF8 and LC_COLLATE
and LC_CTYPE is en_US.UTF-8.
Lets say table person has field name with values likes
name
--
Abc
abc
.dcb
Dcb
$sdf
EDF
en_US.UTF-8
