[DOCS-13840] [SERVER] Database name case sensitivity possibly incorrect Created: 18/Aug/20  Updated: 30/Oct/23  Resolved: 10/Aug/22

Status: Closed
Project: Documentation
Component/s: manual, Server
Affects Version/s: None
Fix Version/s: Server_Docs_20231030

Type: Task Priority: Major - P3
Reporter: Matthew Chiaravalloti Assignee: Dave Cuthbert (Inactive)
Resolution: Fixed Votes: 0
Labels: needs-testing
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:
Days since reply: 1 year, 26 weeks ago
Epic Link: DOCSP-11701

 Description   

Description

The docs for Database Name Case Sensitivity say: "Since database names are case insensitive in MongoDB, database names cannot differ only by the case of the characters."

I have not been able to verify this using the mongodb go driver or the mongo shell. An informal discussion with a member of the query team led me to believe this may not be correct. I'm curious if this is platform dependent or possibly incorrect? I attempted to verify db name case-insensitivity using the go driver and mongo shell on a Mac.

Scope of changes

Impact to Other Docs

MVP (Work and Date)

Resources (Scope or Design Docs, Invision, etc.)



 Comments   
Comment by Githook User [ 10/Aug/22 ]

Author:

{'name': 'Dave Cuthbert', 'email': '69165704+davemungo@users.noreply.github.com', 'username': 'davemungo'}

Message: DOCS-13840 BACKPORT (#1620)
Branch: v4.2
https://github.com/10gen/docs-mongodb-internal/commit/7b3270b4cb389c4d6f28b5385d7d2b5a499f18c4

Comment by Githook User [ 10/Aug/22 ]

Author:

{'name': 'Dave Cuthbert', 'email': '69165704+davemungo@users.noreply.github.com', 'username': 'davemungo'}

Message: DOCS-13840 BACKPORT (#1618)
Branch: v5.0
https://github.com/10gen/docs-mongodb-internal/commit/bfa44dfc1ef333119b375b50d15ce203552f7c82

Comment by Geert Bosch [ 14/Oct/20 ]

The issue for database names is that we have directory per DB, and some filesystems (such as on Windows, Mac) are case insensitive. We could have / should have properly normalized/escaped DB names, but we never did. So we check that we don't allow creation of two databases that only differ in name. Also on Windows we're more restrictive in allowed database names than on other systems.

Comment by Charlie Swanson [ 14/Oct/20 ]

I would be surprised if database names are case insensitive, I have never heard of that. It sounds like it has already been tested so I haven't done my own. Perhaps someone from execution could confirm or knows any historical context. geert.bosch] can you confirm or know anyone who could?

Comment by Adinoyi Omuya [ 14/Oct/20 ]

This is a pretty visible part of our documentation that we should clarify.

CC charlie.swanson to verify the case sensitivity of MongoDB identifiers (database, collection, and field names).

Generated at Thu Feb 08 08:08:51 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.