<html><body><div style="color:#000; background-color:#fff; font-family:tahoma, new york, times, serif;font-size:10pt"><div><span>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.</span></div><div><br></div><div style="font-size: 10pt; font-family: tahoma, 'new york', times, serif; "><div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "><font size="2" face="Arial"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Andrei Kopats <hlamer@tut.by><br><b><span style="font-weight: bold;">To:</span></b> Tayfun Kayhan <tayfun92_kayhan@yahoo.com><br><b><span style="font-weight: bold;">Cc:</span></b> "pyqt@riverbankcomputing.com" <pyqt@riverbankcomputing.com><br><b><span style="font-weight: bold;">Sent:</span></b> Wednesday, November 9, 2011 6:38 AM<br><b><span style="font-weight:
bold;">Subject:</span></b> Re: [PyQt] Storing QString/Unicode in Sqlite Database<br></font><br>
<div id="yiv671873147">Hi<br><br>At first, you should probably use something like <br> unicode(<font size="2">some_lineEdit.text(), 'utf8'), if you want to convert string to unicode.<br>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<br>
http://www.riverbankcomputing.com/static/Docs/PyQt4/html/incompatible_apis.html<br><br>Andrei<br></font><br><div class="yiv671873147gmail_quote">
On Wed, Nov 9, 2011 at 1:20 AM, Tayfun Kayhan <span dir="ltr"><<a rel="nofollow" ymailto="mailto:tayfun92_kayhan@yahoo.com" target="_blank" href="mailto:tayfun92_kayhan@yahoo.com">tayfun92_kayhan@yahoo.com</a>></span> wrote:<br>
<blockquote class="yiv671873147gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 10pt; font-family: tahoma, 'new york', times, serif; "><div><font size="2">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 : </font></div>
<div><font size="2"><br></font></div><div><font size="2"><a rel="nofollow" target="_blank" href="http://self.info">self.info</a> = some_lineEdit.text()</font></div><div><font size="2"><a rel="nofollow" target="_blank" href="http://self.info">self.info</a> = str(u"%s" % some_lineEdit.text()) </font></div>
<div><font size="2"><a rel="nofollow" target="_blank" href="http://self.info">self.info</a> = some_lineEdit.text().toUtf8() </font></div><div><font size="2"><a rel="nofollow" target="_blank" href="http://self.info">self.info</a> = _fromUtf8(some_lineEdit.text()) </font></div>
<div><font size="2"><br></font></div><div><font size="2"><br></font></div><div><font size="2">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.</font></div>
<div><font size="2"><br></font></div><div><font size="2">Everything works fine when i don't enter unicode strings, so problem is exactly the unicode. Any help is appreciated. Thanks.</font></div></div></div><br>_______________________________________________<br>
PyQt mailing list <a rel="nofollow" ymailto="mailto:PyQt@riverbankcomputing.com" target="_blank" href="mailto:PyQt@riverbankcomputing.com">PyQt@riverbankcomputing.com</a><br>
http://www.riverbankcomputing.com/mailman/listinfo/pyqt<br></blockquote></div><br>
</div><br><br></div></div></div></body></html>