MIME-Version: 1.0
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Tue, 12 Oct 2021 17:30:26 +0100
Message-ID: 
 <CA+i5JwZNEkm_geK6wSfc03D-qCaccOsW+_O2Dcc0h1VOBQfz2Q@mail.gmail.com>
Subject: Fault with initcap
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000092636205ce2a5d6c"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5JwZNEkm_geK6wSfc03D-qCaccOsW%2B_O2Dcc0h1VOBQfz2Q%40mail.gmail.com>
Precedence: bulk

--00000000000092636205ce2a5d6c
Content-Type: text/plain; charset="UTF-8"

I tried initcap and found a major problem with it.

Initcap of notemachine is NoteMachine.

Initcap of Sainsbury's Bank is Sainsbury'S bank.

This is not expected.

Anyway to get around this problem?

Regards,

David

--00000000000092636205ce2a5d6c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I tried initcap and found a major problem with it.<div><br=
></div><div>Initcap of notemachine is NoteMachine.</div><div><br></div><div=
>Initcap of Sainsbury&#39;s Bank is Sainsbury&#39;S bank.</div><div><br></d=
iv><div>This is not expected.</div><div><br></div><div>Anyway to get around=
 this problem?</div><div><br></div><div>Regards,</div><div><br></div><div>D=
avid</div></div>

--00000000000092636205ce2a5d6c--