Retrieving JSON data from MongoDB with Hebrew values using Python

Question

I'm new to MongoDB - and I'm having this problem when I retrieve a key from my JSON based MongoDB - it cannot parse Hebrew key values and it returns them blank when I read them.

I had this problem before when I read and wrote to the JSON file locally, using UTF-8 encoding solved this problem like in this example:

with codecs.open('words.json', 'wb', encoding='utf-8') as file:
        json.dump(data, file, ensure_ascii=False)

So my question is, is there a way to retrieve MongoDB data using utf-8 encoding? i'm currently using find() to read my data.

like that:

for x in mycol.find():
  topic = 'בדיקה'
  print(x[topic])

Thanks in advance!

Belly Buster · Accepted Answer · 2021-10-27 18:56:53Z

1

I can't reproduce your error. This snippet seems to work for me:

import pymongo

mycol = pymongo.MongoClient()['mydatabase']['mycol']

mycol.delete_many({})
mycol.insert_one({'בדיקה': 'בדיקה'})

for x in mycol.find():
    topic = 'בדיקה'
    print(x[topic])

prints:

בדיקה

answered Oct 27, 2021 at 18:56

Belly Buster

8,9142 gold badges12 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nyaaaaaaaa Over a year ago

hmmmmmmm, i'll try the same code on different environment to see if it solves the problem and will update.

Nyaaaaaaaa Over a year ago

as i guessed, that was the problem - thank you for checking it with me!

Nyaaaaaaaa · Accepted Answer · 2021-12-08 11:40:06Z

0

As the nice guy above me tried - it was indeed my workspace environment that caused the problem for some reason - if you ever face this kind of problem with mongodb, simple try using a clean different work environment and console to see if it fixed the issue.

***use different code editor

edited Dec 8, 2021 at 11:40

answered Oct 28, 2021 at 15:50

Nyaaaaaaaa

217 bronze badges

1 Comment

Milad Dastan Zand Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Retrieving JSON data from MongoDB with Hebrew values using Python

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related