From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ilmir Mulyukov <ilmir.mulyukov@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Lc_collate & lc_type? whitespace and nbsp unique index...
Date: Mon, 12 Jul 2021 07:29:14 +0200
Message-ID: <1897c8dce7fd6974116c935a50270b33fac09461.camel@cybertec.at> (raw)
In-Reply-To: <CAGiHuoXa+vvSf4Zy7uUd+eh3pFkh4OVxPBB=MRvGqOtuiu=sRQ@mail.gmail.com>
References: <CAGiHuoXa+vvSf4Zy7uUd+eh3pFkh4OVxPBB=MRvGqOtuiu=sRQ@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, ilmir.mulyukov@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Lc_collate & lc_type? whitespace and nbsp unique index...
In-Reply-To: <1897c8dce7fd6974116c935a50270b33fac09461.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox