Wrong results using initcap() with non normalized string

From: Juan José Santamaría Flecha <juanjo(dot)santamaria(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Wrong results using initcap() with non normalized string
Date: 2019-09-20 20:44:11
Message-ID: CAC+AXB0hi9FRMma2uVXAjfn16QPt3x1gphiECqFddSD7EBeW2Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

I have come around a strange situation when using a unicode string
that has non normalized characters. The attached script 'initcap.sql'
can reproduce the problem.

The attached patch can fix the issue.

Regards,

Juan José Santamaría Flecha

Attachment Content-Type Size
initcap.sql application/sql 49 bytes
0001-initcap-non-normalized-string.patch application/x-patch 2.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2019-09-20 21:09:16 Re: Efficient output for integer types
Previous Message Andres Freund 2019-09-20 20:39:05 Re: log bind parameter values on error