Hungarian collation in English Windows server - Mailing list pgsql-general

From Durumdara
Subject Hungarian collation in English Windows server
Date
Msg-id CAEcMXhnGX0DgiC8+ueg-iz2WOfZoKAkQhpMop5Kwn-583p-a1Q@mail.gmail.com
Whole thread Raw
Responses Re: Hungarian collation in English Windows server
List pgsql-general
Dear Members!

One of the customer preinstalled a 9.6 PGSQL server for us.

Today we tried to create and migrate our database.

CREATE DATABASE  yyy
    WITH 
    OWNER = xxx
    ENCODING = 'UTF8'
    LC_COLLATE = 'Hungarian_Hungary.1250' <----
    LC_CTYPE = 'Hungarian_Hungary.1250' <----

But we got error that collation doesn't exists in English Windows server.

How to we add this collation in english server?

What we can do now?

This is a problematic/unpleasant situation because they wait for us, but we didn't use only Hungarian servers where this collation is default.

Thank you for your help!

Regards
    dd


pgsql-general by date:

Previous
From: imp3
Date:
Subject: Command line session and running queries
Next
From: Laurenz Albe
Date:
Subject: Re: Hungarian collation in English Windows server