Top "Collation" questions

Changing the collation of a SQL Server 2012 database

Alter Collation I need to change the collation of one of our databases on a particular server from Latin1_General_…

sql-server collation

Is it possible to have SQL Server convert collation to UTF-8 / UTF-16

In a project I am working on my data is stored in SQL Server, with the collation Danish_Norwegian_CI_…

sql-server unicode utf-8 collation pyodbc

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' in MySQL Stored Procedure

I checked the database table and found it was in latin1_swedish_ci so i've changed it to utf8_general_…

mysql collation

Cannot resolve the collation conflict between "SQL_Latin1_General_Pref_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation

I have the following query: SELECT DISTINCT(po.SONumber) AS [Sales Order No_], po.PONumber AS PoNo, ph.[Buy-from Vendor …

sql-server tsql collation

How to change all the tables in my database to UTF8 character set?

My database is not in UTF8, and I'd like to convert all the tables to UTF8, how can I do …

mysql utf-8 collation alter

Problem with database collation change (SQL Server 2008)

When I tried to change the collation of my existing database (including data) from ARABIC_CS_AS to PERSIAN_100_CS_…

sql-server database sql-server-2008 collation

Using JavaScript to perform text matches with/without accented characters

I am using an AJAX-based lookup for names that a user searches in a text box. I am making the …

javascript string collation non-ascii-characters

utf8_bin vs. utf_unicode_ci

My table Website Website_Name//column name Google Facebook Twitter Orkut Frype Skype Yahoo Wikipedia I i use utf8_bin …

mysql database collation relation

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) within stored procedure

All the tables are in utf_unicode_ci. I've done this to check SELECT table_schema, table_name, column_name, …

mysql ubuntu unicode utf-8 collation

SQL Server: set character set (not collation)

How does one set the default character set for fields when creating tables in SQL Server? In MySQL one does …

sql-server character-encoding collation character-set