Solution for mssql utf8 problem over dblib/pdo driver

Yii 1.1 Tips, Snippets and Tutorials
1

For everyone who have problem with error “htmlspecialchars(): Invalid multibyte sequence in argument” using connetion with mssql over PDO (dblib) ‘dblib:host=domain.com;dbname=DEMO’

In config file freetds.conf set tds protocol version >= 7.0

[global]

tds version = 7.0
2

I have same problem, i need to get UTF-8 chars using MSSQL DBLIB, but it gives me "? ?", but using ASP.NET program its giving me correct data, so its problem with DBLIB or my configurations.

my server configurations is Linux CentOS 6.0 with FreeTDS version - 8.0

i have tried to set

client charset = UTF-8, but it didn’t worked for me.

If anyone have idea please help.

Thanks in Advance.