title: Special character issue while fetching data from PostgreSQL to MS SQL Server, using linked server
body: <p>I am trying to fetch some user entered chanracter, in a filed, in postgre SQL table, into SQL Server using open query. But the data displaying is something different, and not as expected one.</p>
  <p>The Expected is &quot;Lomero, Fr-&gt;d-&gt;ric&quot; but the value coming is as &quot;Lomero, Fr�d�ric&quot;</p>
  <p>The special character &quot;-&gt;&quot; (Arrow as single spl character) is replaced with � (diamond with ?).
  This special character (�) creating issue in our data processing.</p>
  <p>The query I am currently using is as below,</p>
  <pre><code>select name   from openquery(IMAOCTEST,'select clna_client_name as name from XXX_schema.tblimaestro_sync_XXXX where 
  clna_client_code in (66494)')
  </code></pre>
  <p>Is there any way to get the data as expected from PostgreSQL?
  The linked server we created with the below options,</p>
  <pre><code>Collation Compatible - False
  Collation Name - Null
  Use Remote Collation - True
  </code></pre>