From the course: Database Design Fundamentals
Join today to access over 24,700 courses taught by industry experts.
Collation and character sets
From the course: Database Design Fundamentals
Collation and character sets
- [Instructor] We have discussed many of the different aspects of data. Essentially the pieces of the data that make up databases. These are all foundational pieces, very important and critical to the design. I'm going to discuss one more item that is important to consider when you complete your architecture and move from the design to the build phase, just like when building a house. As when building a house, this is very foundational and difficult to change after the fact, and is specific to set and setting. Like a foundation of mud and straw is fine for a dry, hot climate, but not for a wet and cold one, different collations and character sets are appropriate for different situations. Collation defines how characters are compared to each other and sorted. It is critical to sorting and searching. It affects case and accent sensitivity. When comparing items, it is critical to know if an uppercase A will or will not match with a lowercase A. When your data contains accents, it is…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
