[Qt-interest] qsqlquery truncating data at 960045 characters

[Roland Tollenaar]

Hi,

It appears that qsqlquery is truncating the data in a text field 
returned from mssql throguh odbc.

ODBC is not the problem (does a SET TEXTSIZE 2GB by default).

So the only thing remaining is qsqlquery.

Is this limitation known to anyone and if so is there any way to 
overcome it?


This is the snippet:

QueryText="SELECT RollingDoc, FROM rollingdoctable WHERE idx='1'";
ok=query.exec(QueryText);

if(!ok){
	qDebug()<<"Error from getLatestRollingDoc(), select failed";
	QMessageBox::critical(this,"TPS-"+SystemMode,TPSLdb.lastError().text(),"");
}
			
while (query.next()) {
	QString CurrentString=query.value(0).toString();
}

CurrentString returns a string which is cut off at 90045 characters


help appreciated. Qt v 4.5.2 mssql 2005 express

Kind regards,

Roland