public inbox for [email protected]
help / color / mirror / Atom feedLOCALE C.UTF-8 on EDB Windows v17 server
2+ messages / 2 participants
[nested] [flat]
* LOCALE C.UTF-8 on EDB Windows v17 server
@ 2025-06-04 12:23 Dominique Devienne <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Dominique Devienne @ 2025-06-04 12:23 UTC (permalink / raw)
To: pgsql-general
Hi.
For a long time, I was just doing a plain CREATE DATABASE, using
whatever local template1 was using.
Then when v17 came out, I wanted to force UTF-8 for the encoding,
*AND* use the new C.UTF-8 builtin locale, to not depend on libc on
Linux. (which forced me to use template0 explicitly). And since it was
builtin, I just assumed Windows would be fine too. But it's not
apparently not...
I'm using the official v17.5 EDB installer, for the Windows server.
The command I'm using (from a libpq trace) is:
create database "dd_v168" encoding 'UTF8' locale 'C.UTF-8'
locale_provider 'builtin' template template0
On Windows, I'm getting
2025-06-04 14:07:41.227419 B 155 ErrorResponse S "ERROR" V "ERROR" C
"42809" M "invalid LC_COLLATE locale name: "C.UTF-8"" H "If the locale
name is specific to ICU, use ICU_LOCALE." F "dbcommands.c" L "1057" R
"createdb" \x00
Given that v17.5 Windows returns
postgres=# select * from pg_collation where collname ilike '%utf%';
oid | collname | collnamespace | collowner | collprovider |
collisdeterministic | collencoding | collcollate | collctype |
colllocale | collicurules | collversion
-----+-----------+---------------+-----------+--------------+---------------------+--------------+-------------+-----------+------------+--------------+-------------
811 | pg_c_utf8 | 11 | 10 | b | t
| 6 | | | C.UTF-8 |
| 1
(1 row)
While Linux returns:
ddevienne=> select * from pg_collation where collname ilike '%utf%';
oid | collname | collnamespace | collowner | collprovider |
collisdeterministic | collencoding | collcollate | collctype
| colllocale | collicurules | collversion
-------+-----------------+---------------+-----------+--------------+---------------------+--------------+-----------------+-----------------+------------+--------------+-------------
811 | pg_c_utf8 | 11 | 10 | b |
t | 6 | |
| C.UTF-8 | | 1
12351 | C.utf8 | 11 | 10 | c |
t | 6 | C.utf8 | C.utf8
| | |
12354 | en_AU.utf8 | ...
(17 rows)
I tried instead
create database "dd_v168" encoding 'UTF8' locale 'pg_c_utf8'
locale_provider 'builtin' template template0
but that's still KO with
2025-06-04 14:10:58.748508 B 157 ErrorResponse S "ERROR" V "ERROR" C
"42809" M "invalid LC_COLLATE locale name: "pg_c_utf8"" H "If the
locale name is specific to ICU, use ICU_LOCALE." F "dbcommands.c" L
"1057" R "createdb" \x00
First, given the above, I'm no longer sure what I was doing on Linux
was actually using the new built-in collation.
Second, I'm not confused between locales and collations!
What the command supposed to work portably with v17 on both Linux and
Windows server, that uses the new built-in collations (and locale???)
I'd appreciate some clarifications please. --DD
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: LOCALE C.UTF-8 on EDB Windows v17 server
@ 2025-06-05 01:01 Laurenz Albe <[email protected]>
parent: Dominique Devienne <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2025-06-05 01:01 UTC (permalink / raw)
To: Dominique Devienne <[email protected]>; pgsql-general
On Wed, 2025-06-04 at 14:23 +0200, Dominique Devienne wrote:
> The command I'm using (from a libpq trace) is:
>
> create database "dd_v168" encoding 'UTF8' locale 'C.UTF-8'
> locale_provider 'builtin' template template0
>
> On Windows, I'm getting
>
> 2025-06-04 14:07:41.227419 B 155 ErrorResponse S "ERROR" V "ERROR" C
> "42809" M "invalid LC_COLLATE locale name: "C.UTF-8"" H "If the locale
> name is specific to ICU, use ICU_LOCALE." F "dbcommands.c" L "1057" R
> "createdb" \x00
Pilot error. If you use "LOCALE_PROVIDER builtin", you have to specify
BUILTIN LOCALE too:
CREATE DATABASE b
TEMPLATE template0
LOCALE_PROVIDER builtin
BUILTIN_LOCALE 'C.UTF-8'
/* used for aspects other than collation and character type */
LOCALE 'C';
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-06-05 01:01 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-06-04 12:23 LOCALE C.UTF-8 on EDB Windows v17 server Dominique Devienne <[email protected]>
2025-06-05 01:01 ` Laurenz Albe <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox