Re: Lc_collate & lc_type? whitespace and nbsp unique index...

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

 



On Mon, 2021-07-12 at 11:24 +0600, Ilmir Mulyukov wrote:
> I have lc_collate and lc_ctype ru_RU.UTF-8.
> And have two similar value column in different rows.
> Different is that in one string have whitespace symbol, but another non breakable whitespace symbol.
> For example:
> Something(whitespace)wrong
> Something(non breakable space)wrong
> 
> And then when I try to create unique index I catch the error - can not insert duplicate key in row object.
> That means that the two rows are the same.
> 
> Are there any settings in postgresql that can differentiate this two symbols

I find that hard to believe.

Can you provide SQL statements that reproduce the problem?

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com






[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux