Sign inSign up

1kod/postgres

By 1kod

•Updated over 1 year ago

PostgreSQL 17 – UTF-8 Enabled for All Languages

Image
Databases & storage
0

10K+

1kod/postgres repository overview

⁠PostgreSQL 17 – UTF-8 Enabled for All Languages

This Docker image includes PostgreSQL 17 configured with UTF-8 encoding to ensure proper support for all languages. It’s ideal for developers building multilingual applications, with full support for Turkish and all other global character sets.

Features:

PostgreSQL 17

Default database encoding: UTF-8

⁠Start a postgres instance
$ docker run -d --name postgres -p 5432:5432 -e POSTGRES_USER=postgres -e POSTGRES_PASSWORD=mysecretpassword --restart=always -v postgres_data:/var/lib/postgresql/data 1kod/postgres

$ docker run -d --name postgres -e LANG=tr_TR.utf8 -p 5432:5432 -e POSTGRES_INITDB_ARGS="--locale-provider=icu --icu-locale=tr-TR" -e POSTGRES_USER=postgres -e POSTGRES_PASSWORD=mysecretpassword --restart=always -v postgres_data:/var/lib/postgresql/data 1kod/postgres

docker run -d \
  --name postgres \
  --restart=always \
  -e LANG=tr_TR.utf8 \
  -p 5432:5432 \
  -e POSTGRES_INITDB_ARGS="--locale-provider=icu --icu-locale=tr-TR" \
  -e POSTGRES_USER=root \
  -e POSTGRES_PASSWORD=root \
  -v postgres_data:/var/lib/postgresql/data \
  1kod/postgres

⁠Locale and collate example
CREATE DATABASE test ENCODING = 'UTF8' LOCALE = 'tr_TR.utf8' TEMPLATE template0;
CREATE COLLATION "default_coll" (PROVIDER = icu, LOCALE = 'tr-TR-u-ks-level1', DETERMINISTIC = FALSE);

ILIKE Example
  title ilike '%watermelon%' collate "tr-TR-x-icu"

Tag summary

Content type

Image

Digest

sha256:4f6c3e34d…

Size

207.1 MB

Last updated

over 1 year ago

docker pull 1kod/postgres