Hi all,

I tried to run an app with QPSQL, but I found that it doesn't support UNICODE:

qt1.png

and from psql shell:

postgresql2.png

I inserted first row with psql shell therefore you can see unicode is supported inside postgresql.
As postgresql docs says (link):

"Programs using libpq directly need to be aware of this, but not much else does."
So I'm trying to run a test app with QODBC, even if qt docs says that it's better to use specific driver (QPSQL) link:
Note: You should use native drivers in preference to the ODBC driver where they are available. ODBC support can be used as a fallback for compliant databases if no native drivers are available.
I installed driver manager too (following this thread instructions):
posgresql1.png

then compiled and installed qt odbc wrapper:
qt0.jpg

this is my code:


Qt Code: 
  1. //main.cpp:
  2. #include <QCoreApplication>
  3. #include <QSqlRecord>
  4. #include <QSqlQuery>
  5. #include <QSqlError>
  6. #include <QSqlDriver>
  7. #include <QDebug>
  8.  
  9. class Database 
  10. {
  11. 	public:
  12. 		explicit Database();
  13. 		~Database();
  14. 		bool connection();
  15. 	private:
  16. 		QString driverName;
  18. };
  19.  
  20. Database::~Database()
  21. {
  22.     db.close();
  23. }
  24.  
  25. Database::Database() :
  26. 	db(QSqlDatabase::addDatabase("QODBC"))
  27.         //db(QSqlDatabase::addDatabase("QODBC3"))//tried even with this
  28. {
  29. 	driverName = QString("QODBC");
  30. 	db.setDatabaseName("Driver={PostgreSQL};Server=localhost;Port=5432;Database=prova;Uid=postgres;Pwd=*******;");
  31.         //db.setConnectOptions("SQL_ATTR_ODBC_VERSION=SQL_OV_ODBC3");//tried even with this
  32. }
  33.  
  34. bool Database::connection()
  35. {
  36.     if (!db.open()) {
  37. 		qDebug() << QString("Unable to establish a database connection.\n"
  38.                      "This example needs %1 support. Please read "
  39.                      "the Qt SQL driver documentation for information how "
  40.                      "to build it.\n\n"
  41.                      "Click Cancel to exit.").arg(driverName);
  42.         return false;
  43.     }
  44.     return true;
  45. }
  46.  
  47. bool insertTest()
  48. {
  50. 	q.prepare("INSERT INTO p(d) VALUES(:d)");
  51. 	q.bindValue(":d",QString("Questa è un altra prova"));
  52. 	return q.exec();
  53. }
  54.  
  55. int main(int argc, char **argv)
  56. {
  57.     QCoreApplication app(argc,argv);
  58.     const QScopedPointer<Database> database(new Database());
  59.     database->connection();
  60.     if(insertTest())
  61.     {
  62.         qDebug() << "query executed successfully";	
  63.     }else{
  64.         qDebug() << "insert query error";
  65.     }
  67.     q.exec("SELECT * FROM p");
  68.     while(q.next())
  69.     {
  70.        QSqlRecord r = q.record();
  71.        qDebug() << "id=" << r.value("id").toInt();
  72.        qDebug() << "d=" << r.value("d").toString() << '\n';
  73.     }
  74.     return app.exec(); 
  75. }
To copy to clipboard, switch view to plain text mode 

and this is my .pro file:
Qt Code: 
  1. QT         += core gui sql widgets
  2. TARGET      = ScopedPointer
  3. CONFIG     += console
  4. TEMPLATE    = app
  5.  
  6. sql-plugins += odbc
  7.  
  8. SOURCES    += main3.cpp 
  9.  
  10. OBJECTS_DIR = build/o
  11. MOC_DIR     = build/moc
  12. UI_DIR      = build/ui
  13. RCC_DIR     = build/rcc
  14. DESTDIR     = bin
To copy to clipboard, switch view to plain text mode 
I added sql-plugins directive following this thread

Anyway i get this error message:
Qt Code: 
  1. "QODBCResult::exec: No statement handle available" Error: "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
To copy to clipboard, switch view to plain text mode 

as you can see here:
error.png

I'm using Qt 5.2.0. If you need any other information please ask.
Any help would be appreciated, thanks!
Alberto