Thank you, the first one is working well. I tried setting API V2 but it gave an 
error which says that it has been already set to V1. I'll try fixing this, as 
well.


________________________________
From: Andrei Kopats <hla...@tut.by>
To: Tayfun Kayhan <tayfun92_kay...@yahoo.com>
Cc: "pyqt@riverbankcomputing.com" <pyqt@riverbankcomputing.com>
Sent: Wednesday, November 9, 2011 6:38 AM
Subject: Re: [PyQt] Storing QString/Unicode in Sqlite Database


Hi

At first, you should probably use something like 
  unicode(some_lineEdit.text(), 'utf8'), if you want to convert string to 
unicode.
At second, for me all unicode conversion problems disappeared after I started 
using QString API v2. In this case, PyQt methods always return you unicode 
instead of QStrings
http://www.riverbankcomputing.com/static/Docs/PyQt4/html/incompatible_apis.html

Andrei


On Wed, Nov 9, 2011 at 1:20 AM, Tayfun Kayhan <tayfun92_kay...@yahoo.com> wrote:

Hi all, I wanna get texts from some QLineEdits' and QComboBoxes and store them 
in Sqlite DB. But I keep gettin the following error, i also tried using 
following commands that did not worked : 
>
>
>self.info = some_lineEdit.text()
>self.info = str(u"%s" % some_lineEdit.text()) 
>self.info = some_lineEdit.text().toUtf8() 
>self.info = _fromUtf8(some_lineEdit.text()) 
>
>
>
>
>sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a 
>text_factory that can interpret 8-bit bytestrings (like text_factory = str). 
>It is highly recommended that you instead just switch your application to 
>Unicode strings.
>
>
>Everything works fine when i don't enter unicode strings,  so problem is 
>exactly the unicode. Any help is appreciated. Thanks.
>_______________________________________________
>PyQt mailing list    PyQt@riverbankcomputing.com
>http://www.riverbankcomputing.com/mailman/listinfo/pyqt
>
_______________________________________________
PyQt mailing list    PyQt@riverbankcomputing.com
http://www.riverbankcomputing.com/mailman/listinfo/pyqt

Reply via email to