Comparing two URL strings

Поиск

Список

Период

Сортировка

От	mahendrakar s
Тема	Comparing two URL strings
Дата	19 мая 2022 г. 19:53:19
Msg-id	CABkiuWpNDO16QXUoC93WMmjgco3WfzfvuppWe4udSZ4N2d3DqQ@mail.gmail.com обсуждение исходный текст
Ответы	Re: Comparing two URL strings (Alan Hodgson <ahodgson@lists.simkin.ca>)
Список	pgsql-novice

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

От: Tom Lane
Дата: 17 мая 2022 г., 08:42:11
Сообщение: Re: Read rows from a table and process - Need pointers

От: Alan Hodgson
Дата: 19 мая 2022 г., 20:05:36
Сообщение: Re: Comparing two URL strings