FREETDS and UNIXODBC character converting

sql-server linux debian freetds unixodbc
Ali Demirci picture Ali Demirci · May 27, 2010 · Viewed 7.2k times · Source

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..

Answer

dirkb picture dirkb · Nov 28, 2010

You need to set

client charset = 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.

Related questions

how to connect to SQL Server with SQuirreL SQL from non domain registered Linux box?

I need to connect to a SQL 2008 R2 Server from my Linux box that's not registered in my company's domain. I'm trying to use SQuirreL SQL version 3.2.1. I downloaded Microsoft SQL Server JDBC Driver 3.0 and assigned it to SQuirreL on …

Read More
Linux - PHP 7.0 and MSSQL (Microsoft SQL)

Yes, I know that PHP 7.0 removed the extensions needed to connect to MSSQL. FreeTDS was my option prior to PHP 7.0 but now there really is no obvious upgrade path for those needing to still connect to MSSQL. Stupid question, but …

Read More
How to install freetds in Linux?

I am trying to connect to MSSQL server from Ubuntu. I have installed freetds like suggested here. However, when I try to configure /etc/odbc.ini and enter a driver path I have no driver at location /usr/local/freetds/…

Read More