Re: [GENERAL] How to add new Collation language

2017-09-14 Thread Rob Northcott
-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 14 September 2017 14:53 To: Rob Northcott Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to add new Collation language Rob Northcott writes: > From: rob stone [mailto:floripa...@gmail.com] >&g

Re: [GENERAL] How to add new Collation language

2017-09-14 Thread Rob Northcott
-Original Message- From: rob stone [mailto:floripa...@gmail.com] Sent: 14 September 2017 13:38 To: Rob Northcott ; pgsql-general@postgresql.org Subject: Re: [GENERAL] How to add new Collation language On Thu, 2017-09-14 at 11:30 +, Rob Northcott wrote: > How can I ad

[GENERAL] How to add new Collation language

2017-09-14 Thread Rob Northcott
How can I add a collation language to a Postgres server? Specifically, I want to create a new database with collation of English_United Kingdom.1252 but the only options are C, Posix and United States. Even if I select United Kingdom as the locale when installing Postgres I still only have United

Re: [GENERAL] Dealing with number formats when server and client are different locales

2017-09-06 Thread Rob Northcott
-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 06 September 2017 15:49 To: Rob Northcott Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Dealing with number formats when server and client are different locales Rob Northcott writes: > The problem we

Re: [GENERAL] Dealing with number formats when server and client are different locales

2017-09-06 Thread Rob Northcott
-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 06 September 2017 13:36 To: Rob Northcott Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Dealing with number formats when server and client are different locales Rob Northcott writes: > Our application

[GENERAL] Dealing with number formats when server and client are different locales

2017-09-06 Thread Rob Northcott
there is a way to have the server accept either . or , as a decimal separator. Any suggestions or hints very welcome before I get stuck into changing the formatting code in the application. Med vänlig hälsning / Best Regards Rob Northcott Software Developer (UK Office, TEAM Systems) Compilato