Hi! This is actually a limitation of the sql libraries used by PHP (I assume you're using Windows). Try using a cast to a text field:
Select Cast(Field As Text) As Field This should (and I say should because I can't test it right now :) take care of the problem, although it might make your db a bit slower. On Thu, 2002-10-10 at 10:19, Francky wrote: > i have some trouble with mssql_result cause it will return me a result > limitted at 255 char max. > > in my php.ini i set this value : > mssql.textsize=65536 > mssql.textlimit=65536 > > and in SQLSERVER my field type is VARCHAR(2048) > > can you help me please ??? > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php