Postgres Pro
Downloads
Home   >   mailing lists

Re: Comparing two URL strings - Mailing list pgsql-novice

From Alan Hodgson
Subject Re: Comparing two URL strings
Date
Msg-id b09ff2dd84b576ff105be0b431c6e761bd26e1e1.camel@lists.simkin.ca
Whole thread Raw
In response to Comparing two URL strings  (mahendrakar s <mahendrakarforpg@gmail.com>)
Responses Re: Comparing two URL strings
List pgsql-novice
Tree view
On Thu, 2022-05-19 at 22:23 +0530, mahendrakar s wrote:
Hi,
I am facing an issue in comparing two urls (below).

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.

pgsql-novice by date:

Previous
From: mahendrakar s
Date:
Subject: Comparing two URL strings
Next
From: Chris Tsongas
Date:
Subject: Writing my first trigger