What is the column definition in Postgres?

It's a long shot, but I ask because:

1. But the first time it goes wrong is when the business name is: "1-6 CH
   +APMANΓÇÖS END MANAGEMENT COMPANY LIMITED"
   [download]

2. the data arrives correctly in Postgres as '1-6 Chapman's End Managemen
   +t.
   [download]

3. Clearly, Postgres has stored it differently from how it matches it wit
   +h select when there are alphabetic diacritics in the string (actually
   + it's character varying of length 256 in Postgres).
   [download]

Which immediately makes me think of VARCHARvs. NVARCHAR from the SQL Server space. Is there something in Postgres that needs doing to handle Unicode?