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?

Unfortunately Postgres using the operating system support for locales so the names are different for every operating system. See e.g. here: g-loaded.eu/2011/02/27/locale-windows — a_horse_with_no_name, Nov 18 '16 at 9:52

Laurenz Albe · Accepted Answer · 2016-11-18 10:53:21Z

12

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.

answered Nov 18 '16 at 10:53

Laurenz Albe

146k15 gold badges111 silver badges157 bronze badges

1

I was able to create a DB with "-E UTF8 --locale=american_us" but still can't force it to use utf8 collation :)
– Tomasz Dziurko
Nov 18 '16 at 15:43
What is an UTF8 collation? Collations are for ordering strings.
– Laurenz Albe
Nov 18 '16 at 15:54

Add a comment |

1 Answer 1