Обсуждение: problem with latin09 encoding after upgrade to 11.3

Поиск
Список
Период
Сортировка

problem with latin09 encoding after upgrade to 11.3

От
König, Monika (62-24)
Дата:

I’ve solved the problem by setting lc_time to null:

 

 

set lc_time ='';

 

 

instead of lc_time='de_DE'

 

 

 

 

 

 

Von: König, Monika (62-24)
Gesendet: Montag, 20. Mai 2019 07:50
An: 'pgsql-bugs@lists.postgresql.org' <pgsql-bugs@lists.postgresql.org>
Betreff: problem with latin09 encoding after upgrade to 11.3

 

Hey,

 

I’ve just upgraded from postgresql 11.2  to 11.3

 

postgres=# SELECT version(); 

                                                 version                                                

---------------------------------------------------------------------------------------------------------

PostgreSQL 11.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit

 

 

Now the function to_char throws an error:

 

Standardumwandlung von Kodierung »LATIN1« nach »LATIN9« existiert nicht

 

The database  encoding is 'LATIN9', and all went fine until this new version, and latin1 isn’t used anywhere.

 

 

I use yum to manage the versions, but I also can’t  downgrade the version!

 

Is there anything, I can do??

 

 

 

Regards

 

Monika


Bleiben Sie mit unseren städtischen Newslettern auf dem Laufenden. Alle Informationen zum Abo finden Sie auf www.bonn.de/newsletter
Recyclingpapierfreundlichste Stadt Deutschlands 2010 bis 2018.
Bitte prüfen Sie, ob diese Mail wirklich ausgedruckt werden muss.

Re: problem with latin09 encoding after upgrade to 11.3

От
Christoph Berg
Дата:
Re: König, Monika (62-24) 2019-05-20 <D5ECDEBB36D62243AB0551E8A19FE97801F7F1E0EB@SV9206.intern.stadt-bn.de>
> I've solved the problem by setting lc_time to null:
> 
> 
> set lc_time ='';
> instead of lc_time='de_DE'

Hi,

"de_DE" is latin1. For latin9, try "de_DE@euro".

Christoph