Case preservation

The lowercase "a" and uppercase "A" are the two case variants of the first letter in the English alphabet.

In file systems, case preservation is the preservation of the letter case (uppercase or lowercase) of letters in file names. If an attempt is made to create a file named "ThisIsAFile" on a file system that preserves letter case, the file's name will be "ThisIsAFile", rather than, for example, "thisisafile" or "THISISAFILE".

In contrast, a file system that does not preserve letter case will typically store letters in file names either as all lowercase or as all uppercase, and the letter case information will thus be lost. If an attempt is made to create a file named "ThisIsAFile" on a file system that does not preserve letter case, the file's name will be "thisisafile" if letters are stored as all lowercase or "THISISAFILE" if letters are stored as all uppercase.

Combinations of preservation and sensitivity

Case-preserving, case-insensitive

It is possible and common for a system to be case-insensitive, yet case-preserving. This combination is often considered most natural for people to understand, because most people prefer using the correct capitalization but will still recognize others. For example, if someone refers to the "uNiTeD states oF AMERICA," it is understood to mean the United States of America, even though the capitalization is incorrect.

Most of the file systems in macOS, current versions of Microsoft Windows, and all versions of Amiga OS are case-preserving and case-insensitive. Since they are case-insensitive, any combination of lowercase or uppercase letters can be used when referring a file, so that a file named "ThisIsAFile" can be referred to as "thisisafile", "THISISAFILE", "thisISaFILE", and so on. However, since they are case-preserving, when a file is created, the file name will be stored in the combination of lower and upper case letters specified, so that if a file is created as "ThisIsAFile", the name of the file will be "ThisIsAFile" rather than, for example, "thisisafile" or "THISISAFILE".

This means that one cannot save two files with the same name in the same place if the only difference in their file names is capitalization (lowercase or uppercase letters). For example, one cannot have files named readme.txt and Readme.tXT in the same folder.

Non-case-preserving, case-insensitive

A system that is non-case-preserving is necessarily also case-insensitive.

This applies, for example, to Identifiers (column and table names) in some relational databases (for example DB2, Interbase/Firebird, Oracle and Snowflake[1]), unless the identifier is specified within double quotation marks (in which case the identifier becomes case-sensitive).[2]

In a non-case-preserving system, arbitrary capitalization may be used by the system for storage and display, such as for example all letters being store in lowercase (or alternatively all in uppercase). For example, in Oracle Database, a table created with the name CustomersRegion1 will be stored as CUSTOMERSREGION1 (unless it is created under the name "CustomersRegion1", which means that the identifier will be treated as case-sensitive, and therefore must be referenced with that exact casing).

Case-sensitive (results in case-preservation)

Most of the file systems in Unix-like systems other than macOS, such as file systems in Linux, are case-sensitive. This means that there can be two files in the same folder whose only difference is capitalization. For example, readme.txt and Readme.tXT can be found in the same folder.

Examples of file systems

Some examples of file systems with various case-sensitivity and case-preservation are:

Case-sensitive Case-insensitive
Case-preserving UFS, ext3, ext4, HFS Plus (optional), NTFS (in Unix-like systems), APFS (optional) VFAT, FAT32 which is basically always used with long filename support, NTFS, HFS Plus (default), APFS (default)
Non-case-preserving Impossible FAT12, FAT16 only when without long filename support

References

  1. ^ "Identifier requirements | Snowflake Documentation". docs.snowflake.com. Retrieved 2024-02-08.
  2. ^ "Database identifiers, quoting and case sensitivity". Lorenzo Alberton. Retrieved 2024-02-08.

Read other articles:

Alpensia Cross-Country Skiing Centre(37°39′51″N 128°41′07″E / 37.66417°N 128.68528°E / 37.66417; 128.68528) Alpensia Biathlon Centre(37°39′47″N 128°41′16″E / 37.66306°N 128.68778°E / 37.66306; 128.68778) Alpensia Cross-Country Skiing Centre (알펜시아 크로스컨트리 경기장) and Alpensia Biathlon Centre (알펜시아 바이애슬론 경기장) are sport venues in the Alpensia resort, located in Daegwallyeong-myeon, …

2020年夏季奥林匹克运动会波兰代表團波兰国旗IOC編碼POLNOC波蘭奧林匹克委員會網站olimpijski.pl(英文)(波兰文)2020年夏季奥林匹克运动会(東京)2021年7月23日至8月8日(受2019冠状病毒病疫情影响推迟,但仍保留原定名称)運動員206參賽項目24个大项旗手开幕式:帕维尔·科热尼奥夫斯基(游泳)和马娅·沃什乔夫斯卡(自行车)[1]闭幕式:卡罗利娜·纳亚(皮划艇)[2…

Arts university in Tallinn, Estonia Estonian Academy of ArtsEesti KunstiakadeemiaOther nameEKAMottoKunst on töö hing. (Art is the soul of work.)TypepublicEstablished1914Academic affiliationsELIA, CUMULUS, EAAE, KUNO, CIRRUS, Nordic Academy of ArchitectureRectorMart KalmAcademic staff109Administrative staff138Students1210Undergraduates659Postgraduates476Doctoral students62LocationTallinn, EstoniaWebsitewww.artun.ee The Estonian Academy of Arts (Estonian: Eesti Kunstiakadeemia, EKA) is the only …

 本表是動態列表,或許永遠不會完結。歡迎您參考可靠來源來查漏補缺。 潛伏於中華民國國軍中的中共間諜列表收錄根據公開資料來源,曾潛伏於中華民國國軍、被中國共產黨聲稱或承認,或者遭中華民國政府調查審判,為中華人民共和國和中國人民解放軍進行間諜行為的人物。以下列表以現今可查知時間為準,正確的間諜活動或洩漏機密時間可能早於或晚於以下所歸類…

Unmanned spaceflight mission; first flight of the Boeing X-37B Orbital Test Vehicle 1 USA-212OTV-1 during encapsulation prior to maiden launchMission typeDemonstrationOperatorAir Force Space CommandCOSPAR ID2010-015A[1]SATCAT no.36514Mission duration224 days, 9 hours, 24 minutes Spacecraft propertiesSpacecraft typeBoeing X-37BManufacturerBoeingLaunch mass5,400 kg (11,900 lb)[2]PowerDeployable solar array, batteries[2] Start of missionLaunch date22…

Основная статья: Транспорт Конная упряжка долгое время оставалась наиболее распространённым транспортным средством, использующим для передвижения мускульную силу Автомобили сейчас являются самыми распространёнными транспортными средствами, использующими двигатель …

Subprefecture and commune in Occitanie, France You can help expand this article with text translated from the corresponding article in French. (December 2008) Click [show] for important translation instructions. View a machine-translated version of the French article. Machine translation, like DeepL or Google Translate, is a useful starting point for translations, but translators must revise errors as necessary and confirm that the translation is accurate, rather than simply copy-pasting ma…

Geological map of Namibia showing the Damara Belt separating the Congo and Kalahari Cratons The geology of Namibia encompasses rocks of Paleoproterozoic, Mesoproterozoic and Neoproterozoic and Paleozoic to Cenozoic age. About 46% of the countryʼs surface are bedrock exposure, while the remainder is covered by the young overburden sediments of the Kalahari and Namib deserts. The country is famous for its mineral deposits of Tsumeb, as well as many geological sites of interest, from paleontologic…

Town in Guangdong, People's Republic of ChinaQingxi 清溪镇TownQingxi is labeled '20' on this map of DongguanQingxiLocation in GuangdongCoordinates: 22°50′41″N 114°09′51″E / 22.8446°N 114.1643°E / 22.8446; 114.1643CountryPeople's Republic of ChinaProvinceGuangdongPrefecture-level cityDongguanTime zoneUTC+8 (China Standard) Qingxi (Chinese: 清溪; pinyin: Qīngxī) is an industrial town located in the southeastern part of Dongguan prefecture-level ci…

80°S 80°E / 80°S 80°E / -80; 80 This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: East Antarctica – news · newspapers · books · scholar · JSTOR (February 2012) (Learn how and when to remove this message) Part of Antarctica that lies within the Eastern Hemisphere Map of Antarctica with …

British Liberal politician and lawyer Arthur Comyns Carr, circa 1914 Sir Arthur Strettell Comyns Carr (19 September 1882 – 20 April 1965) was a British Liberal politician and lawyer. Family and education Comyns Carr was the son of J. Comyns Carr, a dramatist and art critic. His mother, Alice Comyns Carr (1850–1927), was a costume designer for the theatre. He was born in Marylebone and educated at Winchester College and Trinity College, Oxford. In 1907, he married Cicely Raikes Bromage, the d…

This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these template messages) This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: Humanitarian assistance – news · newspapers · books · scholar · JSTOR (March 2024) (Learn how and when to remo…

← 1867 •  • 1871 → Elecciones generales de 1869[1]​352 escaños en el Congreso de los Diputados Fecha 15 de enero de 1869 Tipo Legislativa Resultados Juan Prim – Coalición Progresista-Liberal CoaliciónPartido ProgresistaUnión LiberalPartido Democrático Escaños obtenidos 236      67.05 % Francisco Pi y Margall – Partido Republicano Federal Escaños obtenidos 85      24.15 % Antonio J…

A questa voce o sezione va aggiunto il template sinottico {{Montagna}} Puoi aggiungere e riempire il template secondo le istruzioni e poi rimuovere questo avviso. Se non sei in grado di riempirlo in buona parte, non fare nulla; non inserire template vuoti.  Bene protetto dall'UNESCOLe Colline del Prosecco di Conegliano e Valdobbiadene Patrimonio dell'umanità TipoCulturali Criterio(v) PericoloNon in pericolo Riconosciuto dal2019 Scheda UNESCO(EN) The Prosecco Hills …

Para otros usos de este término, véase Graffiti. Artículo principal: Hip hop (cultura) Graffiti de Elvis Presley Grafiti en Vigo, España. Grafiti sencillo en una pared en Penco, Chile (2020). Se llama grafiti,[1]​ grafito[2]​ o pintada (las dos primeras, del italiano graffiti, graffire, y esta a su vez, del latín scariphare, «incidir con el scariphus» —estilete o punzón, con el que los antiguos escribían sobre tablas—)[3]​ a una modalidad de pintura libre, des…

كأس الاتحاد الإنجليزي 1921–22 تفاصيل الموسم كأس الاتحاد الإنجليزي  النسخة 47  البلد المملكة المتحدة  التاريخ بداية:10 سبتمبر 1921  نهاية:29 أبريل 1922  المنظم الاتحاد الإنجليزي لكرة القدم  البطل هدرسفيلد تاون  عدد المشاركين 64   كأس الاتحاد الإنجليزي 1920–21  كأس ا…

Billy ZaneBilly Zane tahun 2019LahirWilliam George Zane, Jr.Nama lainBill ZanePekerjaanAktor/SutradaraTahun aktif1985–sekarangSuami/istriLisa Collins (1989–1995) William George Billy Zane Jr. (lahir 24 Februari 1966) merupakan seorang aktor berkebangsaan Amerika Serikat. Dia dilahirkan di Chicago, Illinois, Amerika Serikat. Dia menjadi terkenal saat memerankan karakter Caledon Hockey di film Titanic pada tahun 1997. Filmografi Aktor Back to the Future (1985) .... Match Critters (19…

هذه المقالة تحتاج للمزيد من الوصلات للمقالات الأخرى للمساعدة في ترابط مقالات الموسوعة. فضلًا ساعد في تحسين هذه المقالة بإضافة وصلات إلى المقالات المتعلقة بها الموجودة في النص الحالي. (نوفمبر 2019) دوري الدرجة الأولى الروماني 1924–25 تفاصيل الموسم دوري الدرجة الأولى الروماني …

American Hockey League team in Hershey, Pennsylvania Not to be confused with Hershey bar. Hershey BearsCityHershey, PennsylvaniaLeagueAmerican Hockey LeagueConferenceEasternDivisionAtlanticFounded1932 (T-SHL/EAHL);1938 (IAHL/AHL)Home arenaGiant Center (2002–present)ColorsChocolate, tan, cocoa, white       Owner(s)Hershey Entertainment and Resorts CompanyGeneral managerBryan Helmer (de facto - VP of Hockey Operations)Head coachTodd NelsonCaptainDylan McIlrathMediaThe Pa…

United States historic placeOakland Public LibraryU.S. National Register of Historic PlacesOakland Designated Landmark No. 48 The African American Museum & Library at OaklandAfrican American Museum and LibraryShow map of Oakland, CaliforniaAfrican American Museum and LibraryShow map of CaliforniaAfrican American Museum and LibraryShow map of the United StatesLocation659 14th StreetOakland, CA, U.S.Coordinates37°48′22″N 122°16′35″W / 37.80611°N 122.27639°…