Working with Multilingual Data in SQL Databases through Erlang-Gourab Mitra | Code BEAM America 2025

[CodeSync]

Working with Multilingual Data in SQL Databases through Erlang-Gourab Mitra | Code BEAM America 2025

Working with Multilingual Data in SQL Databases through Erlang-Gourab Mitra | Code BEAM America 2025

This talk was recorded at Code BEAM America in March 2025. If you’re curious about our upcoming event, check https://codebebeamamerica.com

In our diverse digital world, handling multilingual data in databases presents unique challenges that often go unnoticed until they cause critical issues. This talk aims to shed light on the challenges of handling character set encodings in different SQL databases. We’ll dive into the complexities of Unicode support in database systems, examining how seemingly simple concepts like string length and case sensitivity become multifaceted problems when dealing with diverse character sets. This problem will be examined through the lens of a database virtualization platform written in Erlang.

Key sections of this talk will include: 1. Identifying and diagnosing Unicode-related issues in databases 2. Guidelines for writing robust tests to guard against encoding problems 3. Understanding the impact of default settings and implicit resolution rules 4. Implementing best practices for Unicode support in database design and querying

Comments welcome! View the code-sync tag for more Code Sync talks!