Working With Case Insensitive Data

Summary

Let's look at considerations we need to make when In this episode, we'll be looking at a unique index we can use when How does PostgreSQL handle strings in general and what happens with We look at the ILIKE operator and see why it may not be well suited for doing full today I talk about `casefold` and the edge cases it handles that aren't handled by `.lower()`! playlist: ... This video teaches how you can replace values while ignoring All Fabric warehouses by default are configured with our newly launched M Language course ↗️ - goodly.co.in/learn-m-powerquery/ In this video I share a few tips ... 00:45 Structure of the "people" table 01:17 Where is AAron 01:40 Collations in MySQL 03:18 Experimenting with collations 04:53 ... You want to replace all occurrences of a substring with a new substring using PostgreSQL, MySQL, or SQL Server.