note 62230 added to function.mssql-query

MSSQL will not let you use TEXT data in the where clause, TEXT data is BLOG data, its max size is 2,147,483,647 bytes (each character occupies one byte). The varchar and char can have max of 8000 characters, so you can use text data in a where clause if you convert as follows convert(varchar(8000),SOMETEXTDATA) select * from tHistory where myNotes=convert(varchar(8000),SOMETEXTDATA) ---- Server IP: 216.194.113.175 Probable Submitter: 205.238.135.10 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-query.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+62230 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+62230&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+62230&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+62230&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+62230&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+62230&report=yes&reason=non-english Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+62230&report=yes&reason=already+in+docs Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+62230&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+62230&report=yes Search -- http://master.php.net/manage/user-notes.php