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.
>
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 |