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

Reply via email to