[PyQt] Storing QString/Unicode in Sqlite Database

[Tayfun Kayhan]

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 <hlamer at tut.by>
To: Tayfun Kayhan <tayfun92_kayhan at yahoo.com>
Cc: "pyqt at riverbankcomputing.com" <pyqt at 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_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/ffcf53cc/attachment.html>