Re: Comparing two URL strings

Поиск
Список
Период
Сортировка
От mahendrakar s
Тема Re: Comparing two URL strings
Дата
Msg-id CABkiuWoNVzNy=w3Jmv2pHi-ynrHF8bXUsBjccWyjyrJtDjz+gg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Comparing two URL strings  (Alan Hodgson <ahodgson@lists.simkin.ca>)
Список pgsql-novice
Thanks Alan.

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

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 по дате отправления:

Предыдущее
От: Bzzzz
Дата:
Сообщение: Re: Writing my first trigger
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Writing my first trigger