Re: Comparing two URL strings

From: Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)ca>
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: Comparing two URL strings
Date: 2022-05-19 17:05:36
Message-ID: b09ff2dd84b576ff105be0b431c6e761bd26e1e1.camel@lists.simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)user(dot)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(at)user(dot)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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Chris Tsongas 2022-05-19 18:18:48 Writing my first trigger
Previous Message mahendrakar s 2022-05-19 16:53:19 Comparing two URL strings