| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Ilmir Mulyukov <ilmir(dot)mulyukov(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Lc_collate & lc_type? whitespace and nbsp unique index... |
| Date: | 2021-07-12 05:29:14 |
| Message-ID: | 1897c8dce7fd6974116c935a50270b33fac09461.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | postgres dba | 2021-07-12 09:34:03 | Failover happening when kill idle sessions |
| Previous Message | Ilmir Mulyukov | 2021-07-12 05:24:21 | Lc_collate & lc_type? whitespace and nbsp unique index... |