Tommy: PostgreSQL database - Collation and Character Type

[orig]

Hello,

 

How can I create database with different Collation and Character Type than default ones:

Collation: en_US.UTF-8

Character Type: en_US.UTF-8

 

Encoding is UTF which is OK.

 

I would like following:

Collation: hr_HR.utf8

Character Type: hr_HR.utf8

 

I tried with phpPgAdmin but it doesn't have option to change it as phpMyAdmin has.

 

Server: Thommy

Database: orig_2021

user: orig

 

Thank you

 

[Krydos]

Maybe this will help? https://www.postgresql.org/docs/9.1/collation.html

CREATE TABLE test1 (
    a text COLLATE "de_DE",
    b text COLLATE "es_ES",
    ...
);

You should be able to create tables through phppgadmin.

[orig]

Thank you