note 107637 added to ref.mssql
| From: | admin at ersinerol dot com | 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