MIME-Version: 1.0
From: mahendrakar s <mahendrakarforpg@gmail.com>
Date: Thu, 19 May 2022 22:23:19 +0530
Message-ID: 
 <CABkiuWpNDO16QXUoC93WMmjgco3WfzfvuppWe4udSZ4N2d3DqQ@mail.gmail.com>
Subject: Comparing two URL strings
To: pgsql-novice <pgsql-novice@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009fdc2405df60361d"
Archived-At: 
 <https://www.postgresql.org/message-id/CABkiuWpNDO16QXUoC93WMmjgco3WfzfvuppWe4udSZ4N2d3DqQ%40mail.gmail.com>
Precedence: bulk

--0000000000009fdc2405df60361d
Content-Type: text/plain; charset="UTF-8"

Hi,
I am facing an issue in comparing two urls (below).
1)  "https://domain.org/v1.0/users/test@user.org"
2)   "https://domain.org/v1.0/users/test%40user.org"

Comparison of the two strings is failing due to mismatch of '%40'  and (@)
character even though the both urls are the same.
 (gdb) p url
$1 = 0x55d35cfbd1f8 "https://domain.org/v1.0/users/test@user.org"
(gdb) p graph_url
$2 = 0x7ffd82777240 "https://domain.org/v1.0/users/test%40user.org"

Can you please let me know how to compare these two strings.
One way I could think of is convert both the strings to utf-8 but don't
find an utility function to compare the UTF-8 strings.

Thanks,
Mahendrakar.

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

<div dir=3D"ltr"><div>Hi,</div>I am facing an issue=C2=A0in comparing two u=
rls (below).<div><div>1)=C2=A0

&quot;<a href=3D"https://domain.org/v1.0/users/test@user.org">https://domai=
n.org/v1.0/users/test@user.org</a>&quot;</div><div>2)=C2=A0=C2=A0

&quot;<a href=3D"https://domain.org/v1.0/users/test%40user.org">https://dom=
ain.org/v1.0/users/test%40user.org</a>&quot;</div><div><br>Comparison of th=
e two strings is failing due=C2=A0to mismatch of &#39;%40&#39;=C2=A0 and (@=
) character even though the both urls are the same.<br>=C2=A0(gdb) p url<br=
>$1 =3D 0x55d35cfbd1f8 &quot;<a href=3D"https://domain.org/v1.0/users/test@=
user.org">https://domain.org/v1.0/users/test@user.org</a>&quot;<br>(gdb) p =
graph_url<br>$2 =3D 0x7ffd82777240 &quot;<a href=3D"https://domain.org/v1.0=
/users/test%40user.org">https://domain.org/v1.0/users/test%40user.org</a>&q=
uot;<br></div></div><div><br></div><div>Can you please let me know how to c=
ompare=C2=A0these two strings.</div><div>One way I could think of is conver=
t both the strings to utf-8 but don&#39;t find an utility function to compa=
re the UTF-8 strings.</div><div><br></div><div>Thanks,</div><div>Mahendraka=
r.</div></div>

--0000000000009fdc2405df60361d--