Re: Comparing two URL strings

From: mahendrakar s <mahendrakarforpg(at)gmail(dot)com>
To: Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)ca>
Cc: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: Comparing two URL strings
Date: 2022-05-20 07:15:59
Message-ID: CABkiuWoNVzNy=w3Jmv2pHi-ynrHF8bXUsBjccWyjyrJtDjz+gg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Thanks Alan.

On Thu, 19 May 2022 at 22:35, Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)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(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

Browse pgsql-novice by date

  From Date Subject
Next Message hubert depesz lubaczewski 2022-05-20 11:24:59 Re: Writing my first trigger
Previous Message Bzzzz 2022-05-19 19:07:16 Re: Writing my first trigger