Insert field name with dot in mongo document

Question

A Meteor server code tries to insert an object into a Mongo collection. The value of one of the property is a string which contains a dot i.e. ".".

Meteor terminal is complaining :-

Error: key Food 1.1 and drinks must not contain '.'

What does this mean and how to fix it?

 let obj = {
              food: group,
              rest: rule,
              item: item[0],
              key: i
           };

        FoodCol.insert(obj);

edit
The suggested answer by Kishor for replacing the "." with "\uff0E" will produce a space after the dot which is not what a user expects.

It complains about keys, not values. See http://stackoverflow.com/questions/12397118/mongodb-dot-in-key-name — Alex Blex, Jun 23 '16 at 09:28

score 2 · Accepted Answer · edited May 23 '17 at 12:08

2

From this link, How to use dot in field name?

You can replace dot symbols of your field name to Unicode equivalent "\uff0E":

Update: As Fred suggested, please use "\u002E" for "."

edited May 23 '17 at 12:08

Community

1
1

answered Jun 23 '16 at 09:21

Kishor

2,659
4
16
34

1

One problem with this is that `collection.find` return with a space after the dot that was just coded. Where as the original has no space after the dot. – Fred J. Jun 23 '16 at 09:33

score 1 · Answer 2 · answered Sep 27 '17 at 06:30

1

We solved this issue by encoding (Base64) the key before insertion and decode after taking out from the db. Since we consume the document as it is and query fields are different and their keys are not encoded.

But if u want to make query using this key or the key should be readable to the user, this solution will be not be suitable.

answered Sep 27 '17 at 06:30

M. Gopal

404
4
17

This is fugly, but it may just save my bacon.. Thanks! – Corey S. Sep 29 '18 at 18:32

Insert field name with dot in mongo document

2 Answers2