Top "Collation" questions

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

Mysql change column collation and character set of information schema

I want to change column collation and character set of system database information_schema... Can anyone give any input on …

mysql database system collation
What MySQL collation is best for accepting all unicode characters?

Our column is currently collated to latin1_swedish_ci and special unicode characters are, obviously, getting stripped out. We want …

mysql collation
MySQL order by string with numbers

I have strings such as M1 M3 M4 M14 M30 M40 etc (really any int 2-3 digits after a letter) …

mysql sql-order-by collation
how to search for exact string in mysql

I'm trying to search for an exact match of a string in mysql. The string is 'nrew'. But when I …

mysql collation case-sensitive
How do I perform a case-sensitive search and replace in SQL 2000/2005?

In order to perform a case-sensitive search/replace on a table in a SQL Server 2000/2005 database, you must use the …

sql sql-server-2005 sql-server-2000 collation
Complications with SQL Server database having different collation than the server default?

We are in the process of migrating databases off an old SQL Server 2k EE server with default collation "Latin1_…

sql-server collation
MySQL Illegal mix of collations

After viewing my prod logs, I have some error mentionning : [2012-08-31 15:56:43] request.CRITICAL: Doctrine\DBAL\DBALException: An exception occurred …

mysql symfony collation symfony-2.1 fosuserbundle
Illegal mix of collations (utf8mb4_unicode_ci,EXPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

Alright, I give up. I'm 2 days into this error and I need help. Disclaimer: I will need help improving this …

mysql ruby-on-rails utf-8 collation
How to set collation for a connection in SQL Server?

How can i set the collation SQL Server will use for the duration of that connection? Not until i connect …

sql-server sql-server-2005 locale globalization collation
Illegal mix of collations in mySQL

I need to transfer a column from one table to another. The source table has a different collation than the …

mysql character-encoding collation