string_var = '\\u5B9C\\u7F8E'
byte_var = string_var.encode()#utf-8
u_var = byte_var.decode('unicode_escape')
>>>print(u_var)
宜美
>>>'\xc9\xcf\xba\xa3\xca\xd0'.encode('latin1').decode('gbk')#mysql
'上海市'
>>>'\xe7\x9f\xa5\xe9\x81\x93\xe4\xba\x86'.encode('raw_unicode_escape').decode() #python2
'知道了'