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