On Thu, 2025-09-11 at 07:42 +0000, Halil İbrahim AYHAN wrote:
> 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.
There is a lack of SQL statements in your report, but I assume
this is either a user error or a shortcoming of the Windows
C library, both of which are not under our control.
Try like this:
CREATE COLLATION turkish_ci (
PROVIDER = icu,
DETERMINISTIC = FALSE,
LOCALE = 'tr-TR@colStrength=level2'
);
CREATE TABLE tr (st text COLLATE turkish_ci);
INSERT INTO tr VALUES ('ŞİLİ'), ('şili');
SELECT * FROM tr WHERE st = 'şili';
st
══════
ŞİLİ
şili
(2 rows)
You could also define the column with a different collation and
add the COLLATE clause in the query.
Yours,
Laurenz Albe
