i got a wrong data type from mysql by python

Question

I wrote a get data from mysql by phthon like this

 query = ("select distinct packet  from http_sum where downloadspot = 'dilian'")
    cursor.execute(query)
    for (packet) in cursor:
       cdndata_name.append(packet)

As you see,it is so easy.but i got data like this : (u'panzarcn.rar',) how to convert it to string ,thank you

I think you get a tuple back from your cursor. If you need only the first element then use `cdndata_name.append(packet[0])`. — Matthias, Mar 29 '16 at 09:01

score 1 · Accepted Answer · edited May 23 '17 at 12:15

1

That is not a wrong data type, it is unicode and it is the data type you should be using to deal with text in your code. If you realy need to convert it to str look at the answers in the question linked by @Lafexlos.

edited May 23 '17 at 12:15

Community

1
1

answered Mar 29 '16 at 07:54

Stop harming Monica

12,141
1
36
56

i got a wrong data type from mysql by python

1 Answers1