Skip to content

Instantly share code, notes, and snippets.

@ahmeti
Last active April 1, 2023 01:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ahmeti/c28076ca585e93c3756a72d4c811c4d8 to your computer and use it in GitHub Desktop.
Save ahmeti/c28076ca585e93c3756a72d4c811c4d8 to your computer and use it in GitHub Desktop.
CREATE DATABASE test_db ENCODING='UTF-8' LC_COLLATE='tr_TR.UTF-8' TEMPLATE=template0;
CREATE TABLE "public"."test_table" (
"test_name" varchar(100) COLLATE "pg_catalog"."tr_TR.UTF-8" NOT NULL
);
SELECT * FROM pg_collation;
# Mevcut paketleri listeliyoruz.
locale -a
# Yukarıdaki listede tr_TR veya tr_TR.UTF-8 yoksa ekliyoruz.
sudo locale-gen tr_TR
sudo locale-gen tr_TR.UTF-8
# Son olarak güncelleme yapıyoruz.
sudo update-locale
create collation "tr_TR.UTF-8" (LOCALE="tr_TR.UTF-8");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment