Why can't postgresql find spaces in a query with where?

Question

PostgreSQL

There is such a query
SELECT region_id, name, url_name
FROM public.tbl_city
WHERE name = 'Brest region';
and as a result it finds nothing, but the record itself is there. if you search WHERE name = 'Brest'; then everything is fine

Answer 1

Is there a space at the end of the field value 'Brest region' by any chance?

Answer 2

use TRIMto remove all spaces, commas and other extra characters