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

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.

Does this working for you?

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".

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

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

anyone found the solution????

thanks.