public inbox for [email protected]  

help / color / mirror / Atom feed

From: Daniel Verite <[email protected]>
To: Rihad <[email protected]>
Cc: Dominique Devienne <[email protected]>
Cc: pgsql-general General <[email protected]>
Subject: Re: Collation again here
Date: Thu, 08 Jan 2026 17:12:06 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>

	Rihad wrote:

> Looking into pg_collation system table that collation has 
> collprovide="c". First I thought "c" meant libc, but this article states 
> that "c" means PG Internal provider, and libc would have been "l".
> 
> https://medium.com/@adarsh2801/understanding-collations-in-postgresql-648e4fa333e1
> 
> 1. */PostgreSQL Internal Provider (‘c’) /*: Introduced in Postgres 15.
>    This built-in collation support is System/OS agnostic.
> 2. */System Library Provider (‘l’) : /*Uses GNU C library and hence is
>    OS locale dependent.
> 3. */ICU — International Components for Unicode (‘i’) : /*Uses ICU
>    library for unicode-aware collation.

Well, this is quite wrong!

See the doc at [1]:
<quote>
datlocprovider char
Locale provider for this database: b = builtin, c = libc, i = icu
</quote>

Also, the builtin provider has been introduced in pg17, not 15,
and 'l' has never been used in this field.

It looks like hallucination from an AI model.

Quickly reading the rest of the article, it's a mix of good points
and very confusing assertions that would not be expected
from a person proficient in the domain
(for example: writing that en_us.UTF-8 is "case-insensitive")

Unfortunately nowadays AI slop proliferates,  so we need
to be extra cautious on posts from untrusted sources.


[1]: https://www.postgresql.org/docs/current/catalog-pg-database.html

Best regards,
-- 
Daniel Vérité 
https://postgresql.verite.pro/

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Collation again here
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox