From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: ibrahimayhan@hotmail.com.tr
Subject: BUG #19048: PostgreSQL Windows Turkish Search Problem
Date: Thu, 11 Sep 2025 07:43:54 +0000
Message-ID: <19048-21ab9e2c673cf572@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 19048
Logged by: Halil İbrahim AYHAN
Email address: ibrahimayhan@hotmail.com.tr
PostgreSQL version: 17.6
Operating system: Windows Server 2022 Standart
Description:
I am using PostgreSQL Windows version as Turkish Collation
The table contains the record "ŞİLİ" and "şili",
When I Search with ILike, It Does Not Perform Case-Insensitive Searches,
When I search with uppercase letters, I get 1 result, and when I search with
lowercase letters, I get 1 result.
There is no problem with Turkish Collection in Linux Version and 2 results
are given.
This problem occurs in Windows version.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, ibrahimayhan@hotmail.com.tr
Subject: Re: BUG #19048: PostgreSQL Windows Turkish Search Problem
In-Reply-To: <19048-21ab9e2c673cf572@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox