BUG #19048: PostgreSQL Windows Turkish Search Problem

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: ibrahimayhan(at)hotmail(dot)com(dot)tr
Subject: BUG #19048: PostgreSQL Windows Turkish Search Problem
Date: 2025-09-11 07:43:54
Message-ID: 19048-21ab9e2c673cf572@postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 19048
Logged by: Halil İbrahim AYHAN
Email address: ibrahimayhan(at)hotmail(dot)com(dot)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.

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2025-09-11 12:38:11 BUG #19049: Assert failure when using skip arrays on an index key with DESC order
Previous Message Halil İbrahim AYHAN 2025-09-11 07:42:11 PostgreSQL Windows Turkish Search Problem