Message-ID: <b09ff2dd84b576ff105be0b431c6e761bd26e1e1.camel@lists.simkin.ca>
Subject: Re: Comparing two URL strings
From: Alan Hodgson <ahodgson@lists.simkin.ca>
To: pgsql-novice@lists.postgresql.org
Date: Thu, 19 May 2022 10:05:36 -0700
In-Reply-To: 
 <CABkiuWpNDO16QXUoC93WMmjgco3WfzfvuppWe4udSZ4N2d3DqQ@mail.gmail.com>
References: 
	<CABkiuWpNDO16QXUoC93WMmjgco3WfzfvuppWe4udSZ4N2d3DqQ@mail.gmail.com>
Content-Type: multipart/alternative; boundary="=-/fdxOPxHvfvp3nGcwXgT"
User-Agent: Evolution 3.42.4 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/b09ff2dd84b576ff105be0b431c6e761bd26e1e1.camel%40lists.simkin.ca>
Precedence: bulk


--=-/fdxOPxHvfvp3nGcwXgT
Content-Type: text/plain; charset="ISO-8859-15"
Content-Transfer-Encoding: 8bit

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.

--=-/fdxOPxHvfvp3nGcwXgT
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div>On Thu, 2022-05-19 at 22:23 +0530, mahendraka=
r s wrote:</div><blockquote type=3D"cite" style=3D"margin:0 0 0 .8ex; borde=
r-left:2px #729fcf solid;padding-left:1ex"><div dir=3D"ltr"><div>Hi,</div>I=
 am facing an issue&nbsp;in comparing two urls (below).<div><div>1)&nbsp; "=
<a href=3D"https://domain.org/v1.0/users/test@user.org">https://domain.org/=
v1.0/users/test@user.org</a>"</div><div>2)&nbsp;&nbsp; "<a href=3D"https://=
domain.org/v1.0/users/test%40user.org">https://domain.org/v1.0/users/test%4=
0user.org</a>"</div><div><br>Comparison of the two strings is failing due&n=
bsp;to mismatch of '%40'&nbsp; and (@) character even though the both urls =
are the same.<br>&nbsp;(gdb) p url<br>$1 =3D 0x55d35cfbd1f8 "<a href=3D"htt=
ps://domain.org/v1.0/users/test@user.org">https://domain.org/v1.0/users/tes=
t@user.org</a>"<br>(gdb) p graph_url<br>$2 =3D 0x7ffd82777240 "<a href=3D"h=
ttps://domain.org/v1.0/users/test%40user.org">https://domain.org/v1.0/users=
/test%40user.org</a>"<br></div></div><div><br></div><div>Can you please let=
 me know how to compare&nbsp;these two strings.</div><div>One way I could t=
hink of is convert both the strings to utf-8 but don't find an utility func=
tion to compare the UTF-8 strings.</div><div><br></div></div></blockquote><=
div><br></div><div>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 s=
omething only browsers know about.</div><div><br></div><div>You probably ne=
ed to urldecode (or encode) them in your programming language before storin=
g them.</div><div><span></span></div></body></html>

--=-/fdxOPxHvfvp3nGcwXgT--