problem with latin09 encoding after upgrade to 11.3

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

problem with latin09 encoding after upgrade to 11.3

"König, Monika"

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.
Reply | Threaded
Open this post in threaded view
|

problem with latin09 encoding after upgrade to 11.3

"König, Monika"

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: '[hidden email]' <[hidden email]>
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.
Reply | Threaded
Open this post in threaded view
|

Re: problem with latin09 encoding after upgrade to 11.3

Christoph Berg-2
Re: König, Monika (62-24) 2019-05-20 <[hidden email]>
> 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