What is the length maximum for a string data type

2020-02-26 15:22发布

I wasn't able to find any information on the max length for a string data type in MongoDB on the main mongodb.org site. I'm coming from a relational database background and there are usually max lengths. Thank you!

3条回答
疯言疯语
2楼-- · 2020-02-26 15:34

This other question should answer your question:

Documents larger than 4MB (when converted to BSON) cannot be saved to the database. This is a somewhat arbitrary limit (and may be raised in the future); it is mostly to prevent bad schema design and ensure consistent performance.

Note that in the picked answer for that question the commenter mentions that it could be as large as 8mb or 16mb now.

So to answer your question, it's not necessarily that a single string can only be a certain length, but rather that the whole document must be under 16MB.

查看更多
Lonely孤独者°
3楼-- · 2020-02-26 15:38

Follow here

The maximum BSON document size is 16 megabytes.

The maximum document size helps ensure that a single document cannot use excessive amount of RAM or, during transmission, excessive amount of bandwidth. To store documents larger than the maximum size, MongoDB provides the GridFS API. See mongofiles and the documentation for your driver for more information about GridFS.

查看更多
趁早两清
4楼-- · 2020-02-26 15:52

See this:

The maximum BSON document size is 16 megabytes. The maximum document size helps ensure that a single document cannot use excessive amount of RAM or, during transmission, excessive amount of bandwidth. To store documents larger than the maximum size, MongoDB provides the GridFS API.

查看更多
登录 后发表回答