Trolltech Home | QSA-interest Home | Recent Threads | All Threads | Author | Date
All threads index page 1

QSA-interest Archive, February 2006
Problems with Qt + PostgreSQL


Message 1 in thread

I have some problems with Qt + PostgreSQL.
Details are :
 
There is:
1) PostgreSQL 7.4 with server encoding KOI8-R Cyrillic (Russian) on
Redhat
                        ( using PSQL7 driver )
2) Qt 3.3 opensource.
 
or
 
1) PostgreSQL 8.1 with server encoding KOI8-R Cyrillic (Russian) on
WinXP 
                        ( using ODBC3 driver for my application and
PostgreSQLUnicode to create DSN )
2) Qt 4.0 Opensource.
 
and simple query:  QString myQuery ("SELECT alfa , beta FROM tablename
WHERE x = 'word_in_russian'
                                                            and y
='another_word_in_russian'  ") ;
 
 
This query executing successfully in native PostgeSQL clients (psql and
in PgAdmin ) , and 
if write it using embedded SQL. 
 
But when I trying to use QSqlQuery I get errors  : 
 
1) in WinXP
-------QODBCResult::exec: Unable to execute statement: ( query )
              [Microsoft][ODBC Drivers dispatcher] Functions sequence
error.
-------QSqlQuery::value: not positioned on a valid record ( query )
 
2) in RedHat
--------WARNING: Ignoring unconvertible UTF-8 characters '\AD\F8'
(somthing like this) 
 
Finally , I should say , that querys where latin characters only ,
working quite normal
, and without errors.
 
 
How can I force it to work ?
 

Message 2 in thread

Hi,

> I have some problems with Qt + PostgreSQL.

You'll probably get more answers on the qt-interest mailing list:
	http://lists.trolltech.com/qt-interest/

--
 [ signature omitted ]