ID: 11923 Updated by: [EMAIL PROTECTED] -Reported By: [EMAIL PROTECTED] +Reported By: [EMAIL PROTECTED] Status: Open Bug Type: MSSQL related Operating System: Windows2000 PHP Version: 4.0.5 New Comment:
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. Previous Comments: ------------------------------------------------------------------------ [2001-07-06 05:19:11] [EMAIL PROTECTED] 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 ------------------------------------------------------------------------ [2001-07-06 05:14:23] [EMAIL PROTECTED] when you access char(2000),i only get 255 bytes data, why ? ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=11923&edit=1 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, visit: http://www.php.net/unsub.php