Top "Collation" questions

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

mysql check collation of a table

How can I see what collation a table has? I.E. I want to see: +-----------------------------+ | table | collation | |-----------------------------| | t_…

mysql collation
determining the character set of a table / database?

What T-SQL command can be run to find character set of a table or database in SQL Server? edit: Server …

sql-server sql-server-2008-r2 collation
How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?

I'm looking to compare two varchars in SQL, one would be something like Cafe and the other Café is there …

sql-server-2005 tsql collation
Why is MySQL's default collation latin1_swedish_ci?

What is the reasoning behind setting latin1_swedish_ci as the compiled default when other options seem much more reasonable, …

mysql collation
A script to change all tables and fields to the utf-8-bin collation in MYSQL

Is there a SQL or PHP script that I can run that will change the default collation in all tables …

php sql mysql utf-8 collation
store arabic in SQL database

I tried to store Arabic string in SQL 2008 database but it converted to " question mark " why ? and what should I …

sql sql-server sql-server-2008 collation
Can SQL Server SQL_Latin1_General_CP1_CI_AS be safely converted to Latin1_General_CI_AS?

We have a legacy database with some (older) columns using "SQL_Latin1_General_CP1_CI_AS" and more recent changes …

sql sql-server collation
how to change the collate to all the columns of the database?

I would like to change the collation of all the columns of all the tables of my database. In stack …

sql-server collation
Temp Table collation conflict - Error : Cannot resolve the collation conflict between Latin1* and SQL_Latin1*

I can't update temp table. This is my query CREATE TABLE #temp_po(IndentID INT, OIndentDetailID INT, OD1 VARCHAR(50), OD2 …

sql sql-server collation tempdb
Cast collation of nvarchar variables in t-sql

I need to change the collation of an nvarchar variable. By documentation: (...) 3. The COLLATE clause can be specified at several …

sql tsql sql-server-2008 collation string-comparison