Top "Collation" questions

How do I see what character set a MySQL database / table / column is?

What is the (default) charset for: MySQL database MySQL table MySQL column

sql mysql unicode character-encoding collation

What is the best collation to use for MySQL with PHP?

I'm wondering if there is a "best" choice for collation in MySQL for a general website where you aren't 100% sure …

php mysql encoding collation

What's the difference between utf8_general_ci and utf8_unicode_ci?

Between utf8_general_ci and utf8_unicode_ci, are there any differences in terms of performance?

mysql unicode utf-8 collation character-set

What does 'COLLATE SQL_Latin1_General_CP1_CI_AS' do?

I have an SQL query to create the database in SQLServer as given below: create database yourdb on ( name = 'yourdb_…

sql-server database tsql collation

#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

I have a WordPress website on my local WAMP server. But when I upload its database to live server, I …

mysql sql wordpress collation

Troubleshooting "Illegal mix of collations" error in mysql

Am getting the below error when trying to do a select through a stored procedure in MySQL. Illegal mix of …

mysql collation

How to change collation of database, table, column?

The database is latin1_general_ci now and I want to change collation to utf8mb4_general_ci. Is there …

mysql collation

SQL Server default character encoding

By default - what is the character encoding set for a database in Microsoft SQL Server? How can I see …

sql-server character-encoding collation

How to change the default collation of a table?

create table check2(f1 varchar(20),f2 varchar(20)); creates a table with the default collation latin1_general_ci; alter table check2 …

mysql sql collation

UTF-8: General? Bin? Unicode?

I'm trying to figure out what collation I should be using for various types of data. 100% of the content I …

mysql utf-8 collation