note 87674 added to ref.mssql

If you get an error like: PHP Warning: mssql_query(): message: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (severity 16) in /var/www/html/query.php on line 29 There are two solutions: one solution involves casting the data types in the query, the other solution involves changing the version number free tds is using. The first solution is mentioned all over the web and limits what you can return, the second solution will probably only be found right here. Open up your free tds configuration file (/etc/freetds.conf), and change: [global] tds version = 4.2 to this: [global] tds version = 8.0 You don't have to upgrade any packages, but by default, freetds tries to use an older version (if you installed freetds using yum or apt-get). ---- Server IP: 92.48.74.199 Probable Submitter: 205.232.70.82 ---- Manual Page -- http://www.php.net/manual/en/ref.mssql.php Edit -- https://master.php.net/note/edit/87674 Del: integrated -- https://master.php.net/note/delete/87674/integrated Del: useless -- https://master.php.net/note/delete/87674/useless Del: bad code -- https://master.php.net/note/delete/87674/bad+code Del: spam -- https://master.php.net/note/delete/87674/spam Del: non-english -- https://master.php.net/note/delete/87674/non-english Del: in docs -- https://master.php.net/note/delete/87674/in+docs Del: other reasons-- https://master.php.net/note/delete/87674 Reject -- https://master.php.net/note/reject/87674 Search -- https://master.php.net/manage/user-notes.php