Top "Collation" questions

Collation refers to a set of rules that determine how data is sorted and compared.

Change encoding (collation?) of SQL Server 2008 R2 to UTF-8

We'd like to move our Confluence system to a SQL Server 2008 R2. Now, since Confluence uses UTF-8 encoding, I'd need …

utf-8 sql-server-2008-r2 collation ucs2
Discover collation of a MySQL column

I previously created a MySQL table and now I want to find out what collation some of the fields are …

mysql collation
SQL Collation conflict when comparing to a column in a temp table

I have a SQL query that compares a value in the database to a constant: SELECT * FROM my_table INNER …

sql collation
What is the best MySQL collation for German language

I am building a web site in German language, So I will be using characters like ä, ü, ß etc., So what are …

mysql encoding collation
Which of utf8 collations is the best?

I want a UTF8 collation for supporting: English Persian Arabic French Japanese Chinese Does UTF8_GENERAL_CI support all these …

mysql collation
How to change collation of all rows from latin1_swedish_ci to utf8_unicode_ci?

I ignorantly used the default latin1_swedish_ci character encoding for all of the varchar rows in my database during …

mysql collation
MySQL Convert latin1 data to UTF8

I imported some data using LOAD DATA INFILE into a MySQL Database. The table itself and the columns are using …

sql mysql collation load-data-infile
SQL_Latin1_General_CP1_CS_AS vs Latin1_General_CS_AS

What are the exact differences between the SQL_Latin1_General_CP1_CS_AS and Latin1_General_CS_AS collations in …

sql-server collation
What effects does using a binary collation have?

While answering this question, I became uncertain about something that I didn't manage to find a sufficient answer to. What …

mysql database binary string-comparison collation