[PyQt] Storing QString/Unicode in Sqlite Database

Andrei Kopats hlamer at tut.by
Wed Nov 9 04:38:33 GMT 2011


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_kayhan at 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 at riverbankcomputing.com
> http://www.riverbankcomputing.com/mailman/listinfo/pyqt
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.riverbankcomputing.com/pipermail/pyqt/attachments/20111109/5724f5c5/attachment.html>


More information about the PyQt mailing list