[PHP] MSSQL_RESULT Problem

2002-10-11 Thread Francky

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




Re: [PHP] MSSQL_RESULT Problem

2002-10-11 Thread Marco Tabini

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