But the first time it goes wrong is when the business name is: "1-6 CHAPMANΓÇÖS END MANAGEMENT COMPANY LIMITED"

##</code><code>##

the data arrives correctly in Postgres as '1-6 Chapman's End Management.

##</code><code>##

Clearly, Postgres has stored it differently from how it matches it with select when there are alphabetic diacritics in the string (actually it's character varying of length 256 in Postgres).