Posted inDatabase
Advanced Vietnamese Search in PostgreSQL and MySQL: Collation, Unaccent, and Index Optimization
Vietnamese diacritics break naive database search queries. Here's how to configure Collation in MySQL and the Unaccent extension in PostgreSQL — plus functional and GIN indexes — so searches work correctly without a performance hit.