QTDS - SQLServer 2000 - Win strange behaviour

[jpujolf]

I've had a problem. I presumed was my mistake, as usual . But after some investigation I think I've found a Qt-bug. Anybody can test this code in a Win-xx environment to confirm my suspects ?

Environment : mingw32 3.4.2, SQLServer 2000-SP4, Qt 4.3.0, driver QTDS

#include <QApplication>
#include <QtSql/QSqlDatabase>
#include <QtSql/QSqlQuery>
#include <QtSql/QSqlRecord>
#include <QVariant>
#include <fstream>
 
using namespace std;
 
int main(int argc, char *argv[])
{
  ofstream DEBUG;
  DEBUG.open ( "LOG.TXT" );
 
  QCoreApplication app(argc, argv);
 
  QSqlDatabase db = QSqlDatabase::addDatabase ( "QTDS" );
  db.setHostName     ( "<HOSTNAME>" );
  db.setDatabaseName ( "<DATABASE>" );
  db.setUserName     ( "sa" );
  db.setPassword     ( "<pwd>" );
  db.open();
 
  QSqlQuery QRY ( db );
  // here you MUST put a query that select at least a field longer than 255 chars 
  // ( 300 , 500 , 800, ... )
  QString SEL = "SELECT FIELD_LONGER_THAN_255_CHAR FROM TABLE";
 
  QRY.exec ( SEL );
  QRY.last();	
  QRY.first();
 
  while ( QRY.isValid() )
  {
    DEBUG << (const char *)QRY.record().value ( 0 ).toString().toAscii() << "\n";
    QRY.next();
  }
 
  DEBUG.close();
  return 0;
}

#include <QApplication>
#include <QtSql/QSqlDatabase>
#include <QtSql/QSqlQuery>
#include <QtSql/QSqlRecord>
#include <QVariant>
#include <fstream>

using namespace std;

int main(int argc, char *argv[])
{
  ofstream DEBUG;
  DEBUG.open ( "LOG.TXT" );

  QCoreApplication app(argc, argv);

  QSqlDatabase db = QSqlDatabase::addDatabase ( "QTDS" );
  db.setHostName     ( "<HOSTNAME>" );
  db.setDatabaseName ( "<DATABASE>" );
  db.setUserName     ( "sa" );
  db.setPassword     ( "<pwd>" );
  db.open();

  QSqlQuery QRY ( db );
  // here you MUST put a query that select at least a field longer than 255 chars 
  // ( 300 , 500 , 800, ... )
  QString SEL = "SELECT FIELD_LONGER_THAN_255_CHAR FROM TABLE";

  QRY.exec ( SEL );
  QRY.last();	
  QRY.first();

  while ( QRY.isValid() )
  {
    DEBUG << (const char *)QRY.record().value ( 0 ).toString().toAscii() << "\n";
    QRY.next();
  }
	
  DEBUG.close();
  return 0;
}

To copy to clipboard, switch view to plain text mode 

In windows, when the field is longer than 255 chars ( SQL analizer from Microsoft returs all the data ) the value returned from Qt's classes is "cutted" to 255 chars.

VERY Strange....

[jpujolf]

Hi all,

Nobody uses this combination ( mingw - SQLServer - Win32 ) ??

I'm f...ed....