Postgres Pro
Downloads
Home   >   mailing lists

Linux x Windows LOCALE/ENCODING compatibility - Mailing list pgsql-general

From Carlos Henrique Reimer
Subject Linux x Windows LOCALE/ENCODING compatibility
Date
Msg-id AANLkTin2WEMAMECHwFLY9u3goexqJyNw+k4-nxctqdW5@mail.gmail.com
Whole thread Raw
Responses Re: Linux x Windows LOCALE/ENCODING compatibility  (Filip Rembiałkowski <filip.rembialkowski@gmail.com>)
List pgsql-general
Tree view
Hi,
 
I currently have my PostgreSQL server running in a windows box and now we're migrating it to a Linux operational system.
 
Current windows configuration:
pg_controldata shows the LC_COLLATE and LC_CTYPE are Portuguese_Brasil.1252
psql \l command shows we have databases with encoding WIN1252 and UTF8
 
New Linux box:
Which --locale and --encoding options should I use for the INITDB command to have a compatible locale and encoding cluster?
Which --encoding option should I use in the CREATEDB command to have a compatible encoding database?
 
Thank you!
Reimer

pgsql-general by date:

Previous
From: Yan Cheng CHEOK
Date:
Subject: Re: Slow connection once the PC is network connected
Next
From: Alexander Farber
Date:
Subject: async queries in Perl and poll()/select() loop - how to make them work together?