ID: 11923 Comment by: Roland dot Grassmann at Jungheinrich dot de Reported By: chenwumail at 163 dot net Status: No Feedback Bug Type: MSSQL related Operating System: Windows2000 PHP Version: 4.0.5 New Comment:
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 Previous Comments: ------------------------------------------------------------------------ [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] [EMAIL PROTECTED] 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. ------------------------------------------------------------------------ [2001-07-06 05:19:11] chenwumail at 163 dot net My SQL Server is SQL Server 2000, My PHP is PHP 4.05 My OS is windows 2000 My table name is news,defined like: keyword varchar(2000), content text I can save data to keyword but when i get is ,it only 255 bytes, I view database, data is true save in table. example: $result=mssql_query("select keyword from news"); print strlent(mssql_result($result,0,0)); ------- 255 ------------------------------------------------------------------------ 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
