sql-serverlinuxdebianfreetdsunixodbc

FREETDS and UNIXODBC character converting

ive got an error to fix. its: 

[FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted

when i use turkish characters to insert i get this error. my question is how can i disable that converting thing? im connecting to sql server via freetds and unixodbc.

thanks..

Solution

  • You need to set

    clientcharset = UTF-8

    in your freetds.conf file and read it from odbc.ini by setting the Servername option to the connection definition in freetds.com. See this explanation and my blog post.