Blog Posts on collation

SQL Server Error: Cannot resolve the collation conflict by jd.Obedoza on Mar 25, 2010Ever encountered this same error message on SQL Server? Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AI” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation. Here is a sample of two tables...

TSQL Latin Collation Error by Being (me) on Oct 1, 2009Error encountered:Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.I'm not sure if it's as convenient with the earlier versions but SQL Server 2008 allows you to easily...

TSQL Latin Collation Error by Email Forward on Aug 17, 2009Error encountered:Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.I'm not sure if it's as convenient with the earlier versions but SQL Server 2008 allows you to easily...

Opting For the Right Weight Loss Method by autopilotincome101.com on Jun 30, 2009Combining physical exercise and a reasonable dieting plan is the crucial strategy to get a successful weight loss. Though all of us are aware of it, when it comes to brass tacks, we all struggle and wonder where to commence and how to go about initi...

How to Change/Convert your MySQL Database Collation to utf8 (a verbose sample) by StreetSmartin'IT on Apr 24, 2008Scenario: You have a very big database(schema)(more than 500 mb), and you wish to convert it say from latin1 to utf8(for reasons you can keep :) probably because you want your DB to be able to accommodate an app that can be fully localized (like Mamb...