Creating utf-8 database in Postgresql on Windows10

Question

I am trying to create utf-8 database on windows 10:

createdb.exe -h localhost -p 53131 -U user -E UTF8 -T template0 -l en_US.utf-8 test777

But response is:

createdb: database creation failed: ERROR:  invalid locale name: "en_US.utf-8"

Any clues?

Answer 1

You should use "English_United States" or "en-US", see the Microsoft documentation about locale names.

PostgreSQL allows the creation of a UTF8 database with any locale on Windows (see the documentation).

By the way, the initdb option for specifying the locale is --locale and not -l.