MIME-Version: 1.0
References: 
 <CABkiuWpNDO16QXUoC93WMmjgco3WfzfvuppWe4udSZ4N2d3DqQ@mail.gmail.com>
 <b09ff2dd84b576ff105be0b431c6e761bd26e1e1.camel@lists.simkin.ca>
In-Reply-To: <b09ff2dd84b576ff105be0b431c6e761bd26e1e1.camel@lists.simkin.ca>
From: mahendrakar s <mahendrakarforpg@gmail.com>
Date: Fri, 20 May 2022 12:45:59 +0530
Message-ID: 
 <CABkiuWoNVzNy=w3Jmv2pHi-ynrHF8bXUsBjccWyjyrJtDjz+gg@mail.gmail.com>
Subject: Re: Comparing two URL strings
To: Alan Hodgson <ahodgson@lists.simkin.ca>
Cc: pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000ccf65705df6c433c"
Archived-At: 
 <https://www.postgresql.org/message-id/CABkiuWoNVzNy%3Dw3Jmv2pHi-ynrHF8bXUsBjccWyjyrJtDjz%2Bgg%40mail.gmail.com>
Precedence: bulk

--000000000000ccf65705df6c433c
Content-Type: text/plain; charset="UTF-8"

Thanks Alan.

On Thu, 19 May 2022 at 22:35, Alan Hodgson <ahodgson@lists.simkin.ca> wrote:

> On Thu, 2022-05-19 at 22:23 +0530, mahendrakar s wrote:
>
> 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.
>
>
> They aren't multi-byte; converting them to UTF-8 wouldn't change anything.
> As is, they are in fact different strings, as "URL" is something only
> browsers know about.
>
> You probably need to urldecode (or encode) them in your programming
> language before storing them.
>

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

<div dir=3D"ltr">Thanks Alan.</div><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">On Thu, 19 May 2022 at 22:35, Alan Hodgson &l=
t;<a href=3D"mailto:ahodgson@lists.simkin.ca">ahodgson@lists.simkin.ca</a>&=
gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0=
px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>=
<div>On Thu, 2022-05-19 at 22:23 +0530, mahendrakar s wrote:</div><blockquo=
te type=3D"cite" style=3D"margin:0px 0px 0px 0.8ex;border-left:2px solid rg=
b(114,159,207);padding-left:1ex"><div dir=3D"ltr"><div>Hi,</div>I am facing=
 an issue=C2=A0in comparing two urls (below).<div><div>1)=C2=A0 &quot;<a hr=
ef=3D"https://domain.org/v1.0/users/test@user.org" target=3D"_blank">https:=
//domain.org/v1.0/users/test@user.org</a>&quot;</div><div>2)=C2=A0=C2=A0 &q=
uot;<a href=3D"https://domain.org/v1.0/users/test%40user.org" target=3D"_bl=
ank">https://domain.org/v1.0/users/test%40user.org</a>&quot;</div><div><br>=
Comparison of the 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" target=3D"_blank">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" target=3D"_blank=
">https://domain.org/v1.0/users/test%40user.org</a>&quot;<br></div></div><d=
iv><br></div><div>Can you please let me know how to compare=C2=A0these two =
strings.</div><div>One way I could think of is convert both the strings to =
utf-8 but don&#39;t find an utility function to compare the UTF-8 strings.<=
/div><div><br></div></div></blockquote><div><br></div><div>They aren&#39;t =
multi-byte; converting them to UTF-8 wouldn&#39;t change anything. As is, t=
hey are in fact different strings, as &quot;URL&quot; is something only bro=
wsers know about.</div><div><br></div><div>You probably need to urldecode (=
or encode) them in your programming language before storing them.</div><div=
><span></span></div></div>
</blockquote></div>

--000000000000ccf65705df6c433c--