Re: Hungarian collation in English Windows server

2018-08-24 Thread Tom Lane
Durumdara writes: > Dear Laurenz! >> You have to install the collation on the Windows maching, not in >> PostgreSQL. > We could add languages. As I remember my coll. told me that Hungarian lang. > pack is installed in that machine. > But maybe this is different thing. > What we need to do to PGSQ

Re: Hungarian collation in English Windows server

2018-08-24 Thread Durumdara
Dear Laurenz! > You have to install the collation on the Windows maching, not in PostgreSQL. We could add languages. As I remember my coll. told me that Hungarian lang. pack is installed in that machine. But maybe this is different thing. What we need to do to PGSQL see that collation? Would you

Re: Hungarian collation in English Windows server

2018-08-22 Thread Laurenz Albe
Durumdara wrote: > 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. You have to install the col

Hungarian collation in English Windows server

2018-08-22 Thread Durumdara
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