python unicode 转码,python将unicode转换为字符串

I got my results from sqlite by python, it's like this kind of tuples: (u'PR:000017512',)

However, I wanna print it as 'PR:000017512'. At first, I tried to select the first one in tuple by using index [0]. But the print out results is still u'PR:000017512'. Then I used str() to convert and nothing changed. How can I print this without u''?

解决方案

You're confusing the string representation with its value. When you print a unicode string the u doesn't get printed:

>>> foo=u'abc'

>>> foo

u'abc'

>>> print foo

abc

Update:

Since you're dealing with a tuple, you don't get off this easy: You have to print the members of the tuple:

>>> foo=(u'abc',)

>>> print foo

(u'abc',)

>>> # If the tuple really only has one member, you can just subscript it:

>>> print foo[0]

abc

>>> # Join is a more realistic approach when dealing with iterables:

>>> print '\n'.join(foo)

abc