ODBC Driver issue
-
wrote on 14 Jul 2011, 13:26 last edited by
Does the Backend DB you use support Unicode? If so, could you post your DB structure to make sure there's no error in it.
-
wrote on 15 Jul 2011, 06:11 last edited by
I'm using MaxDB (Version 7.6). The Table "DBPARAMETERS" says "_UNICODE" = "NO" and "DEFAULT_CODE" = "ASCII", which means that the varchar datatype is stored as ascii. However, the same software with an older Qt-Version (4.1) displays the Umlauts correctly.
Here's some background information: I've been trying to integrate an older software into a new environment. The old software was compiled in VS2003 with Qt 4.1. Now I've compiled it in VS2010 with Qt 4.7.3. Both versions run properly on Windows 7 with the same ODBC-driver. However, the old one displays the Umlauts correctly, while the new one does not. Therefore, I think it is the newer Qt-Version that is giving me a hard time. -
wrote on 15 Jul 2011, 09:31 last edited by
This webside says that MaxDB up to and including version 7.6 uses the ASCII-characterset ISO 8859/1.2 (if you chose to use Ascii): http://maxdb.sap.com/doc/7_7/44/bb285be00215b2e10000000a155369/content.htm
-
wrote on 15 Jul 2011, 09:43 last edited by
Try
@
QTextCodec::setCodecForLocale(QTextCodec::codecFromName("latin1"));
@
at the beginning of your application. -
wrote on 15 Jul 2011, 10:05 last edited by
Neither
@
QTextCodec::setCodecForLocale(QTextCodec::codecForName("Latin1"));
@
nor
@
QTextCodec::setCodecForLocale(QTextCodec::codecForName("latin1"));
@
works. -
wrote on 15 Jul 2011, 10:16 last edited by
The following code changes the "�" to a "?". I do not know if that helps at all, to get to the source of the error.
Original code:
@
QString name =q2.value(1).toString(); //q2 being the QSqlQuery
@
Changed code (that changes the "�" to a "?"):
@
QByteArray encodedString = q2.value(1).toByteArray();
QTextCodec *codec = QTextCodec::codecForName("ISO 8859-1");
QString name = codec->toUnicode(encodedString);
@ -
wrote on 19 Jul 2011, 12:30 last edited by
Qt Version is 4.7.3
Db Version is Oracle Enterprise 11.2.0.1.0
Os is Win7 Ultimate x64 -
wrote on 22 Jul 2011, 12:40 last edited by
Anyone any idea???
-
wrote on 9 Aug 2011, 09:47 last edited by
bump
Still having this issue... -
wrote on 13 Apr 2012, 13:22 last edited by
I have the same problem with a Visual Fox Pro database with the ISO Latin-1 character encoding. I use Qt 4.7.4.