Wrong character encoding with FreeTDS connection to sql server -
i want access mssql server r through freetds. used rodbc library , set connection. however, have problem encoding. serbian characters appear \u009, \u008, etc.
the server has sql_latin1_general_cp1_ci_as collation while system utf-8. tried adding clientcharset=utf-8;servercharset=cp1252; odbc.ini, output mssql query doesn't change. version of sql server 12.
i tried looking online can't figure out what's wrong.
here's odbc.ini:
[srvnm] driver=freetds description=odbc freetds server= myserverip port=1433 readonly=yes tds_version=7.4 servercharset=cp1252 clientcharset=utf-8
Comments
Post a Comment