Last active
April 1, 2023 01:34
-
-
Save ahmeti/c28076ca585e93c3756a72d4c811c4d8 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE DATABASE test_db ENCODING='UTF-8' LC_COLLATE='tr_TR.UTF-8' TEMPLATE=template0; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE "public"."test_table" ( | |
"test_name" varchar(100) COLLATE "pg_catalog"."tr_TR.UTF-8" NOT NULL | |
); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT * FROM pg_collation; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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