mongodb - Python dictionary : removing u' chars

Question

How do I remove u chars from the following dictionary?

{u'name': u'A', u'primary_key': 1}  

This data is coming from Mongo Database find() query

so that it looks like

{'name': 'A', 'primary_key': 1}

Answer 1

Some databases such as Sqlite3 let you define converter and adapter functions so you can retrieve text as str rather than unicode. Unfortunately, MongoDB doesn't provide this option for any of the commonly needed types such as str, decimal or datetime:

• http://api.mongodb.org/python/current/tutorial.html#a-note-on-unicode-strings
• http://api.mongodb.org/python/current/faq.html#how-can-i-store-decimal-decimal-instances
• http://api.mongodb.org/python/current/faq.html#how-can-i-save-a-datetime-date-instance

Having eliminated Mongo options, that leaves writing Python code to do the conversion after the data is retrieved. You could write a recursive function that traverses the result to convert each field.

As a quick-and-dirty alternative, here is a little hack that may be of use:

>>> import json, ast
>>> r = {u'name': u'A', u'primary_key': 1}
>>> ast.literal_eval(json.dumps(r))
{'name': 'A', 'primary_key': 1}