note 95473 added to function.mssql-query

I've run into the error: "Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library" I'm not using FreeTDS. If you don't want to type-cast your variables and would rather just convert all fields from ntext to something else, like varchar, this script will do the trick. http://www.clearsightdesign.com/free-scripts/ntext-fields-to-varchar/ It will select all ntext fields and attempt to change the data type to whatever you specify. I defaulted it to varchar(1200) but use whatever you want. It will also just generate the SQL queries if you would prefer to run them yourself. - Jamon Holmgren ---- Server IP: 69.147.83.197 Probable Submitter: 71.216.201.233 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-query.php Edit -- https://master.php.net/note/edit/95473 Del: integrated -- https://master.php.net/note/delete/95473/integrated Del: useless -- https://master.php.net/note/delete/95473/useless Del: bad code -- https://master.php.net/note/delete/95473/bad+code Del: spam -- https://master.php.net/note/delete/95473/spam Del: non-english -- https://master.php.net/note/delete/95473/non-english Del: in docs -- https://master.php.net/note/delete/95473/in+docs Del: other reasons-- https://master.php.net/note/delete/95473 Reject -- https://master.php.net/note/reject/95473 Search -- https://master.php.net/manage/user-notes.php