Top "Collation" questions

In MySQL, which collation should I choose?

When I create a new MySQL database through phpMyAdmin, I have the option to choose the collation (e.g.-default, …

mysql collation

Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='

I got this error; Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for …

mysql collation

How do I sort unicode strings alphabetically in Python?

Python sorts by byte value by default, which means é comes after z and other equally funny things. What is the …

python sorting unicode internationalization collation

Are column and table name case sensitive in MySQL?

If I have a column names called category_id and Category_Id, are they different? And if I have table …

mysql collation case-sensitive

MySQL Collation: latin1_swedish_ci Vs utf8_general_ci

What should I set for Collation when creating tables in MySQL: latin1_swedish_ci or utf8_general_ci What is …

mysql database-design collation

Query to show all tables and their collation

Is there a query that can be run in mysql that shows all tables and their default collation? Even better …

mysql schema collation

Difference between utf8mb4_unicode_ci and utf8mb4_unicode_520_ci collations in MariaDB/MySQL?

I logged into MariaDB/MySQL and entered: SHOW COLLATION; I see utf8mb4_unicode_ci and utf8mb4_unicode_520_ci …

mysql unicode mariadb collation

MySQL - Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'UNION'

How do I fix that error once and for all? I just want to be able to do unions in …

sql mysql unicode union collation

UTF8 Postgresql Create Database Like MySQL (including character set, encoding, and lc_type)

For the following MySQL create database statement, what would be the equivalent in postgresql?: CREATE DATABASE IF NOT EXISTS `scratch` …

postgresql encoding character-encoding collation ddl

How to set collation of a column with SQL?

Originally, I created my SQL Server database on a local computer. I set its collation to Latin1_General_CI_AI …

sql sql-server collation