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 ]