Postgres Pro
Downloads
Home   >   mailing lists

Comparing two URL strings - Mailing list pgsql-novice

From mahendrakar s
Subject Comparing two URL strings
Date
Msg-id CABkiuWpNDO16QXUoC93WMmjgco3WfzfvuppWe4udSZ4N2d3DqQ@mail.gmail.com
Whole thread Raw
Responses Re: Comparing two URL strings
List pgsql-novice
Tree view
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.

Thanks,
Mahendrakar.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Read rows from a table and process - Need pointers
Next
From: Alan Hodgson
Date:
Subject: Re: Comparing two URL strings