Importing a Windows database (in en_GB.CP1252) to linux

Hello,

I have a (*custom*) backup created on a Windows machine in en_GB.CP1252
encoding. And of course, some characters can't be imported because they
don't exist in UTF-8.

So I created a new cluster on PG18 port 5433 initialized in WIN1252
encoding:

$ \l imlocal
                                           List of databases
 Name   | Owner | Encoding | Locale Provider | Collate | Ctype | Locale
| ICU Rules | Access privileges
---------+-------+----------+-----------------+---------+-------+--------+-----------+-------------------

imlocal | cat   | WIN1252  | libc            | C       | C     | ∅    |
∅       | ∅
(1 row)

I am now trying to import the data in that database but I keep getting
this error:

$ pg_restore -p 5433 -t csakafl -d imlocal imlocal20251127.backup
pg_restore: error: COPY failed for table "csakafl": ERROR:  invalid byte
sequence for encoding "UTF8": 0x92
CONTEXT:  COPY csakafl, line 298

So pg_restore still thinks I want to use UTF8.

So I created an en_GB.CP1252 locales definitions folder like this:

mkdir ~/locales
cd ~/locales
cp cp /usr/share/i18n/charmaps/CP1252.gz .
gunzip CP1252.gz
localedef -cv -i en_GB -f CP1252 ./en_GB.CP1252

Then I now want to use this to restore my database so I tried setting:

setenv LOCPATH ~/locales
setenv LC_ALL en_GB.CP1252
setenv LANG en_GB.CP1252

And even forcing LC_ALL when launching pg_restore:

$ LC_ALL=en_GB.CP1252 pg_restore -p 5433 -t csakafl -d imlocal
imlocal20251127.backup
pg_restore: error: COPY failed for table "csakafl": ERROR:  invalid byte
sequence for encoding "UTF8": 0x92
CONTEXT:  COPY csakafl, line 298

What am I doing wrong?

Thanks for your help,

JC