Using freetds and unixODBC to run queries with accents (á,é,í,ó,ú) on SQL Server
<p>I am using <strong>Ubuntu 14.04</strong> with <strong>freetds</strong> and <strong>unixODBC</strong> to connect to a <strong>2008 Microsoft SQL Server</strong>. I tested the connection with <code>tsql</code> and <code>isql</code> and it worked correctly. While using <code>isql -v</code> if I include accents (á,é,í,ó,ú) in the query I receive the following response:</p>
<blockquote>
<p>[37000][unixODBC][FreeTDS][SQL Server]Incorrect syntax near '?'.</p>
<p>[ISQL]ERROR: Could not SQLExecute</p>
</blockquote>
<p>While installing freetds and unixODBC packages I received a warning message saying that special characters would not be accepted unless an extra package was but I can't which one it was. To try and solve this problem I uninstalled freetds and unixODBC, reinstalled them and did not receive any warning message but I am still receiving the same error message when including accents in the queries.</p>
<p>PS: This is the first question I make so sorry if it is vague or incomplete.</p>