MSSQL "for xml" limit
Posted: Thu Oct 04, 2007 9:55 am
The problem is: when I use mssql query "select ID,Name from Table for xml raw", it returned only 2033-2048 bytes (4K div 2). How it can be solved?
For about, this problem doesn't exists, when I try this query from ASP.NET projects.
I use freeTDS for select Unicode data.
Editing php.ini and increasing mssql.textsize and mssql.textlimit not solved this problem.
Editing freetds.conf and increasing text size not solved this problem.
Anyone knows how it can be solved?
Thanks.
For about, this problem doesn't exists, when I try this query from ASP.NET projects.
I use freeTDS for select Unicode data.
Editing php.ini and increasing mssql.textsize and mssql.textlimit not solved this problem.
Editing freetds.conf and increasing text size not solved this problem.
Anyone knows how it can be solved?
Thanks.