#11923 [Com]: when you access char(2000),i only get 255 bytes data, why ?

ID: 11923 Comment by: hollmanlp at gmail dot com Reported By: chenwumail at 163 dot net Status: No Feedback Bug Type: MSSQL related Operating System: Windows2000 PHP Version: 4.0.5 New Comment: anyone found the solution???? thanks. Previous Comments: ------------------------------------------------------------------------ [2004-01-07 11:00:16] Roland dot Grassmann at Jungheinrich dot de It's not a bug, it's a feature... Microsoft does not support access to any MS SQL Server >6.5 features by use of isql and db-library which seems to be used by php_mssql.dll. See: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_mta_01_5cmk.asp This means: * no varchar etc with lengths > 255 * no unicode (ntext, nchar, nvarchar) fields. If anyone finds a solution, please mail me! Thanx, Roland ------------------------------------------------------------------------ [2002-08-07 02:49:44] mbretter at jawa dot at not a bug in php, a bug in microsoft. This is a limitation of the db-libraray of mssql. Try select cast (keyword as text) from news ------------------------------------------------------------------------ [2002-07-08 01:00:10] php-bugs at lists dot php dot net No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2002-06-07 11:02:20] k.schroeder@php.net Does this working for you? ------------------------------------------------------------------------ [2002-02-07 23:45:02] ollie at cronky dot net Its to with the TDS protocol (used for connecting to MSSQL/Sybase) apparently. On windows its out of date and therefore doesn't support more that 255 chars, you can use a convert statement (to convert the output of the column to text) or just change the datatype to text. Or use the ODBC functions. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/11923 -- Edit this bug report at http://bugs.php.net/?id=11923&edit=1