|
Python and MYSQL Resultset
|
|
Mar-31-2021, 09:37 PM
Hi - I am using Python to get results from mysql database.
The results displayed shows quotes and a u concatenated to the results? Not sure why? Result:(1, u'userone', u'password1')
Apr-01-2021, 12:12 PM
Read this thread https://stackoverflow.com/questions/3920...ql/3920490
Apr-02-2021, 12:41 AM
(Apr-01-2021, 12:12 PM)kashcode Wrote: Read this thread https://stackoverflow.com/questions/3920...ql/3920490 Thank you. It did remove the u from the result set. After adding the use_unicode=True ,charset="utf8" to the db connection string. Now, I still have single quotes left in the result set? |
|
|
| Possibly Related Threads… | |||||
| Thread | Author | Replies | Views | Last Post | |
| Parsing bs4 Resultset | gw1500se | 4 | 5,825 |
Nov-09-2021, 04:06 AM Last Post: snippsat |
|
| AttributeError: ResultSet object has no attribute 'get_text' | KatMac | 1 | 4,780 |
May-07-2021, 05:32 PM Last Post: snippsat |
|
| TypeError: must be str, not ResultSet | HiImNew | 3 | 8,615 |
Feb-15-2018, 07:48 AM Last Post: buran |
|