title: Error: ORA-28500:[Oracle][ODBC SQL Server Driver]String data, right truncation
body: <p>We are trying to connect to Sql Server 2005 via Oracle 11gR2 gateway and when we query a view that gets data from Sql Server , we get this error : </p>
  
  <pre><code>Error: ORA-28500:[Oracle][ODBC SQL Server Driver]String data, right truncation 
  </code></pre>
  
  <p>I have commented out some columns in the query running at Oracle, and it worked. The commented columns are in data type of VARHCAR(30), but there are other fields which are VARCHAR(30) too.</p>
  
  <p>Is there any workaround for this error, if I add these 3 columns that fail the whole query, everything will be O.K., I tried to rename these fields at the view running at Sql Server 2005 which is the data source, no result. </p>
  
  <p>Both ODBC and SQL Server drivers are installed, we are using the SQL Server driver,"dg4msql". 
  Oracle charset is AL32UTF8.</p>