Collation and Character Type

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Collation and Character Type

JORGE MALDONADO
Hi,

I installed PostgreSQL 11.5 for Windows and set it to the character set "Spanish Mexico 1252" (this is asked during installation). 
When I create a new database, I am asked for "Collation" and "Character type" and the options shown are: "C", "POSIX" and "Spanish_Mexico.1252". Before clicking on the "Save" button to actually create it, I go to the "SQL" tab and I see something like this:

CREATE DATABASE riopoderoso
    WITH
    OWNER = postgres
    TEMPLATE = template0
    ENCODING = 'WIN1252'
    LC_COLLATE = 'Spanish_Mexico.1252'
    LC_CTYPE = 'Spanish_Mexico.1252'
    TABLESPACE = riopoderoso
    CONNECTION LIMIT = -1;

If I want a different value for "LC_COLLATE" and "LC_CYPE", can I just copy this code, change such values and run it as a query in the "SQL Shell"? Is this a correct procedure?
I wonder if I need to do some additional configuration so other character sets appear in the "Collation" and "Character type" shown below. However, it seems to me that the CREATE DATABASE command in the documentation shows that this is enough.

image.png

Regards,
Jorge Maldonado

Libre de virus. www.avast.com
Reply | Threaded
Open this post in threaded view
|

Re: Collation and Character Type

David G Johnston
On Mon, Sep 14, 2020 at 3:09 PM JORGE MALDONADO <[hidden email]> wrote:
Before clicking on the "Save" button to actually create it, I go to the "SQL" tab and I see something like this:

CREATE DATABASE riopoderoso
    WITH
    OWNER = postgres
    TEMPLATE = template0
    ENCODING = 'WIN1252'
    LC_COLLATE = 'Spanish_Mexico.1252'
    LC_CTYPE = 'Spanish_Mexico.1252'
    TABLESPACE = riopoderoso
    CONNECTION LIMIT = -1;

If I want a different value for "LC_COLLATE" and "LC_CYPE", can I just copy this code, change such values and run it as a query in the "SQL Shell"? Is this a correct procedure?

Yes, intercepting the auto-generated SQL command and modifying it is valid - just remember you need to be connected to a database in order to execute SQL so if you are not already in that position you will need to do that as well.

I wonder if I need to do some additional configuration so other character sets appear in the "Collation" and "Character type" shown below.

You would need to inquire about how that field is populated from the providers of pgAdmin.  If you type in a different value the server will inform you whether it understands what you mean.

David J.