Horton

BUG #19048: PostgreSQL Windows Turkish Search Problem

PG Bug reporting form <noreply@postgresql.org>

View thread
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: ibrahimayhan@hotmail.com.tr
Date: 2025-09-11T07:43:54Z
Lists: pgsql-bugs 
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.