[PHP] MSSQL_RESULT Problem

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

Re: [PHP] MSSQL_RESULT Problem

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