PostgreSql accent issue

Question

SELECT LOWER(p."Name") FROM "User" p WHERE LOWER(p."Name") LIKE 'admin%';

In this query, I want to retrieve the data from "ADMIN" as "admin", but it comes as "admİn". There is an accent problem. How can I solve this globally in my database? Valid for all tables. I don't want to use the unaccent function because I'm using it via .Net.

I tried the Unaccent function, but I can't write this in every query.

Example enter image description here

Does this answer your question? Does PostgreSQL support "accent insensitive" collations? — Richard
– Richard, Commented Apr 30, 2024 at 9:52

Mehdi Kacim · Accepted Answer · 2024-04-30 09:50:01Z

0

The encoding seems to be the problem. You can refer to the official PostGres documentation

answered Apr 30, 2024 at 9:50

Mehdi Kacim

1525 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Engin Can Over a year ago

How can I change an existing database?

Mehdi Kacim Over a year ago

see ref stackoverflow.com/questions/5090858/…

Collectives™ on Stack Overflow

PostgreSql accent issue

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related