New Microsoft SQL Server Video Tutorial: Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server

Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server - view details

Do you know what a collation is in SQL Server? What's the difference between CI and CS collations? How about CP1 versus CP1252 - what's the difference (nothing)? If these questions baffle you, then you might enjoy watching Scott Whigham explain how string (character) data works in SQL Server. If you are trying to understand how SQL Server works with case-sensitive data (or case-insensitive data), then you'll get a lot out of this video. Learn the difference between SQL Collations, Windows Locale, Code Pages, and whether or not a lower-case "a" sorts before or after an upper-case "A"

---

• Source: SQL Server videos
• Category: Transact-SQL Basics: Queries, Stored Procedures, Functions and more
• Skill Level: 300 (Intermediate)
• Length: 9:39 (5.37MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: collate, collation, sql collation