title: Oracle data is returned with spaces between characters
body: <p>I am trying to retrieve data(select *..) from a SQL Server database to an Oracle database using dblinks. In my SQL Server database, I have a columns <code>AddressLine1</code> and <code>AddressLine2</code> of type <code>nvarchar</code>. </p>
  
  <p>I am running the below script in SQL Developer (v 4.1.3.20). The results appear having spaces between characters. I used Benthic and SQL Plus and the results are same, spaces between characters.</p>
  
  <pre><code>SELECT 
      c.CandidateID,
      pa."AddressLine1", pa."AddressLine2"
  FROM 
      CANDIDATES c --Oracle table
  INNER JOIN 
      PostalAddress@HIM pa ON pa."EntityID" = c.CandidateID   -- SQL Server table
  </code></pre>
  
  <p>--@HIM --dblink name` </p>
  
  <p>This screenshot shows the results (when copying blank spaces are copied):</p>
  
  <p><a href="https://i.stack.imgur.com/slq3U.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/slq3U.png" alt="Results"></a></p>
  
  <p>I also tried to cast the results to <code>varchar</code> and the results are same. I tried to trim the spaces and also tried to replace the whitespaces with NULL but the results remain the same. </p>
  
  <p>Any suggestions would be greatly appreciated. Thank you.</p>