How to sort text in sqlite3 with specified locale? How to Sort Text in SQ Lite3 with a Specified Locale Sorting text data in SQ Lite3 can be challenging especially when dealing with various languages and their u 3 min read 09-10-2024 9
What is the difference between latin1_general_ci and utf8_bin in MySQL Understanding the Differences Between latin1 general ci and utf8 bin Collations in My SQL When working with databases in My SQL understanding character sets and 3 min read 09-10-2024 6
Change Collation on SQL server issue Changing Collation in SQL Server Understanding the Issue and Solutions When working with SQL Server you may encounter the need to change the collation of your d 3 min read 07-10-2024 3
How to convert character set from ISO8859_1 to UTF8 in Firebird? Converting Character Sets in Firebird From ISO 8859 1 to UTF 8 Many databases including Firebird utilize character sets to represent textual data When you encou 3 min read 07-10-2024 6
Mysterious Postgres string comparison result when string contains certain symbol characters The Case of the Disappearing String Understanding Postgres String Comparisons with Special Characters Have you ever encountered a situation where a simple strin 2 min read 06-10-2024 10
Wrong sorting in mysql (InnoDB - utf8mb4_slovak_ci) Understanding Wrong Sorting in My SQL Inno DB utf8mb4 slovak ci When working with My SQL databases especially in a multi language context sorting data can becom 3 min read 28-09-2024 10
Average of two strings in alphabetical/lexicographical order with `PAD SPACE` Rules Calculating the Average of Two Strings in Lexicographical Order with Padding Rules When dealing with strings in programming one interesting challenge is to find 2 min read 15-09-2024 15
how to change the collate to all the columns of the database? How to Change the Collation of All Columns in a SQL Server Database Many SQL Server users struggle with managing collation settings in their databases especiall 3 min read 06-09-2024 14