Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.os.linux.advocacy > #689639

Re: Case Insensitive File Systems -- Torvalds Hates Them

From rbowman <bowman@montana.com>
Newsgroups comp.os.linux.advocacy
Subject Re: Case Insensitive File Systems -- Torvalds Hates Them
Date 2025-04-29 01:13 +0000
Message-ID <m7andaF6bbqU1@mid.individual.net> (permalink)
References <pan$4068a$3910f4f1$8cbecede$9e42905e@linux.rocks> <20250428075602.0000416d@gmail.com> <8UOPP.1839103$BrX.1740657@fx12.iad> <m79tuoF2bf6U2@mid.individual.net> <RWQPP.125643$oJg.52379@fx17.iad>

Show all headers | View raw

On Mon, 28 Apr 2025 15:46:56 -0400, CrudeSausage wrote:

> The biggest issue I envision anyone having with case sensitivity is not
> remembering what they saved a certain file as. However, if you know that
> the document deals with green eggs, searching for it despite not
> remembering the document filename should be trivial.

I was talking about databases. In DB2 

'SELECT author FROM books WHERE title LIKE 'green eggs%' 

is only going to match 'green eggs' exactly. If you're not sure how the 
record was stored you would need LOWER(title). 

The equivalent directory search would be something like

find . -name "*.txt" | xargs grep -i "green eggs"

The difference is the directory search is probably going to be a one-shot. 
The SQL statement may be executed thousands of times and LOWER() is 
costly. 

I'm curious how SQL Server or Access handles case insensitivity in the 
internals. However it's done it's faster than explicit conversions at 
runtime.

Back to comp.os.linux.advocacy | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Case Insensitive File Systems -- Torvalds Hates Them Farley Flud <ff@linux.rocks> - 2025-04-27 10:21 +0000
  Re: Case Insensitive File Systems -- Torvalds Hates Them John Ames <commodorejohn@gmail.com> - 2025-04-28 07:56 -0700
    Re: Case Insensitive File Systems -- Torvalds Hates Them Farley Flud <fsquared@fsquared.linux> - 2025-04-28 15:45 +0000
    Re: Case Insensitive File Systems -- Torvalds Hates Them CrudeSausage <crude@sausa.ge> - 2025-04-28 13:27 -0400
      Re: Case Insensitive File Systems -- Torvalds Hates Them rbowman <bowman@montana.com> - 2025-04-28 17:58 +0000
        Re: Case Insensitive File Systems -- Torvalds Hates Them CrudeSausage <crude@sausa.ge> - 2025-04-28 15:46 -0400
          Re: Case Insensitive File Systems -- Torvalds Hates Them rbowman <bowman@montana.com> - 2025-04-29 01:13 +0000
            Re: Case Insensitive File Systems -- Torvalds Hates Them Borax Man <rotflol2@hotmail.com> - 2025-04-30 10:29 +0000
              Re: Case Insensitive File Systems -- Torvalds Hates Them rbowman <bowman@montana.com> - 2025-04-30 17:48 +0000
    Re: Case Insensitive File Systems -- Torvalds Hates Them RonB <ronb02NOSPAM@gmail.com> - 2025-04-28 19:50 +0000
      Re: Case Insensitive File Systems -- Torvalds Hates Them CrudeSausage <crude@sausa.ge> - 2025-04-28 16:44 -0400
        Re: Case Insensitive File Systems -- Torvalds Hates Them rbowman <bowman@montana.com> - 2025-04-29 01:33 +0000
      Re: Case Insensitive File Systems -- Torvalds Hates Them rbowman <bowman@montana.com> - 2025-04-29 01:16 +0000
  Re: Case Insensitive File Systems -- Torvalds Hates Them John Ames <commodorejohn@gmail.com> - 2025-04-28 11:12 -0700
    Re: Case Insensitive File Systems -- Torvalds Hates Them Farley Flud <ff@linux.rocks> - 2025-04-28 18:56 +0000
      Re: Case Insensitive File Systems -- Torvalds Hates Them John Ames <commodorejohn@gmail.com> - 2025-04-28 12:31 -0700
        Re: Case Insensitive File Systems -- Torvalds Hates Them Farley Flud <ff@linux.rocks> - 2025-04-28 20:03 +0000
          Re: Case Insensitive File Systems -- Torvalds Hates Them ant@zimage.comANT (Ant) - 2025-04-29 01:30 +0000
            Re: Case Insensitive File Systems -- Torvalds Hates Them rbowman <bowman@montana.com> - 2025-04-29 04:13 +0000
              Re: Case Insensitive File Systems -- Torvalds Hates Them Farley Flud <fsquared@fsquared.linux> - 2025-04-29 10:00 +0000
          Re: Case Insensitive File Systems -- Torvalds Hates Them John Ames <commodorejohn@gmail.com> - 2025-05-05 09:23 -0700
      Re: Case Insensitive File Systems -- Torvalds Hates Them Andreas Eder <a_eder_muc@web.de> - 2025-04-29 10:18 +0200
      Re: Case Insensitive File Systems -- Torvalds Hates Them Borax Man <rotflol2@hotmail.com> - 2025-04-29 14:18 +0000
      Re: Case Insensitive File Systems -- Torvalds Hates Them Andreas Dehmel <blackhole.8.zarquon42@spamgourmet.com> - 2025-04-29 20:11 +0200
        Re: Case Insensitive File Systems -- Torvalds Hates Them Farley Flud <ff@linux.rocks> - 2025-04-29 19:04 +0000
          Re: Case Insensitive File Systems -- Torvalds Hates Them Andreas Dehmel <blackhole.8.zarquon42@spamgourmet.com> - 2025-04-30 21:09 +0200
            Re: Case Insensitive File Systems -- Torvalds Hates Them Stéphane CARPENTIER <sc@fiat-linux.fr> - 2025-05-02 20:14 +0000
              Re: Case Insensitive File Systems -- Torvalds Hates Them Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-05-02 23:59 +0000
                Re: Case Insensitive File Systems -- Torvalds Hates Them Chris Ahlstrom <OFeem1987@teleworm.us> - 2025-05-03 08:09 -0400
                Re: Case Insensitive File Systems -- Torvalds Hates Them The Natural Philosopher <tnp@invalid.invalid> - 2025-05-03 13:52 +0100
                Re: Case Insensitive File Systems -- Torvalds Hates Them Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-05-03 22:54 +0000
                Re: Case Insensitive File Systems -- Torvalds Hates Them Stéphane CARPENTIER <sc@fiat-linux.fr> - 2025-05-09 21:25 +0000
                Re: Case Insensitive File Systems -- Torvalds Hates Them Joel <joelcrump@gmail.com> - 2025-05-09 17:53 -0400
                Re: Case Insensitive File Systems -- Torvalds Hates Them Richard Kettlewell <invalid@invalid.invalid> - 2025-05-10 09:38 +0100
                Re: Case Insensitive File Systems -- Torvalds Hates Them The Natural Philosopher <tnp@invalid.invalid> - 2025-05-10 09:49 +0100
                Re: Case Insensitive File Systems -- Torvalds Hates Them Richard Kettlewell <invalid@invalid.invalid> - 2025-05-10 11:06 +0100
                Re: Case Insensitive File Systems -- Torvalds Hates Them Stéphane CARPENTIER <sc@fiat-linux.fr> - 2025-05-10 11:20 +0000
                Re: Case Insensitive File Systems -- Torvalds Hates Them Andreas Eder <a_eder_muc@web.de> - 2025-05-03 16:48 +0200
    Re: Case Insensitive File Systems -- Torvalds Hates Them Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-04-29 02:43 +0000
      Re: Case Insensitive File Systems -- Torvalds Hates Them candycanearter07 <candycanearter07@candycanearter07.nomail.afraid> - 2025-04-29 19:10 +0000
  Re: Case Insensitive File Systems -- Gates Loves Them (was: Case Insensitive File Systems -- Torvalds Hates Them) Tyrone <none@none.none> - 2025-04-29 21:18 +0000
    Re: Case Insensitive File Systems -- Gates Loves Them (was: Case Insensitive File Systems -- Torvalds Hates Them) Farley Flud <ff@linux.rocks> - 2025-04-30 08:50 +0000

csiph-web