Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: rbowman Newsgroups: comp.os.linux.advocacy Subject: Re: Case Insensitive File Systems -- Torvalds Hates Them Date: 28 Apr 2025 17:58:49 GMT Lines: 25 Message-ID: References: <20250428075602.0000416d@gmail.com> <8UOPP.1839103$BrX.1740657@fx12.iad> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: individual.net 6/tDxFtonHeKvCgnClFN4QS9zoh5HFR4OoW3c1i6W+m0aVMLly Cancel-Lock: sha1:mG1ACmMXyZuZvJlXRTMZYcIMB1c= sha256:9i64DSuNubN9k9GRpe9DTh1uD1GLNERnUISvabte6cQ= User-Agent: Pan/0.160 (Toresk; ) Xref: csiph.com comp.os.linux.advocacy:689610 On Mon, 28 Apr 2025 13:27:32 -0400, CrudeSausage wrote: > On 4/28/25 10:56, John Ames wrote: >> On Sun, 27 Apr 2025 10:21:55 +0000 Farley Flud wrote: >> >>> We all should hate case insensitive file systems. >> >> Why? > > I imagine that his argument will be something along the lines of "it's > fascism for my system not to be able to differentiate between Green the > surname and green the colour." I actually agree that if I name a file > green.odt, it should be obvious that it is the text I wrote about how > much I love the colour and not the text I wrote about the Green family. > However, most people are not that bright and would prefer case > insensitivity because they would prefer to name a document > greencolour.odt or greenfamily.odt. Otoh is you're dealing with a database you very seldom care if the field is 'Green Eggs', 'green eggs', GREEN EGGS', or 'Green eggs'. However with a case sensitive database like DB2 you have to use UCASE or LOWER, relatively expensive operations at run time, or make sure all data is entered in lower or upper case. Ironically, DB2 is case insensitive for table and column names.