note 107637 added to ref.mssql

From: Date: Thu, 23 Feb 2012 08:16:08 +0000
Subject: note 107637 added to ref.mssql
Groups: php.notes 
Request: Send a blank email to php-notes+get-186308@lists.php.net to get a copy of this message
Here is the solution for ; "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." Reason is you had column with nvarchar(max) data type in my SQL Server database table. When you use nvarchar(max) and stores more than 4000 characters (8000 bytes) SQL Server uses different method to store the data similar to old TEXT data type. What it does in that case, the in-row data is replaced by a pointer to one or more separate pages where the data is stored. If you use nvarchar(max) in the sqlserver database table field, just limit the (max). for exp: nvarchar(16) or nvarchar(32) THIS WILL SURELY FIX YOUR PROBLEM ---- Server IP: 69.147.83.197 Probable Submitter: 88.248.64.130 ---- Manual Page -- http://www.php.net/manual/en/ref.mssql.php Edit -- https://master.php.net/note/edit/107637 Del: integrated -- https://master.php.net/note/delete/107637/integrated Del: useless -- https://master.php.net/note/delete/107637/useless Del: bad code -- https://master.php.net/note/delete/107637/bad+code Del: spam -- https://master.php.net/note/delete/107637/spam Del: non-english -- https://master.php.net/note/delete/107637/non-english Del: in docs -- https://master.php.net/note/delete/107637/in+docs Del: other reasons-- https://master.php.net/note/delete/107637 Reject -- https://master.php.net/note/reject/107637 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#186308) next »