what is collation error?

Question

hi my sql VS project getting collatation error while saving a new record.I have seen enough answers in the wesites but none of them fixed me,, System.Data.SqlClient.SqlException HResult=0x80131904 Message=Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation. Source=.Net SqlClient Data Provider StackTrace: can anyone know how to fix this?

Laxmidhar Sahoo · Answer

I think Mixing collations within the same instance of SQL Server is a source of virtually endless problems unless the entire system was carefully written to exist with multiple collations - and doing that is also a big hassle. example CREATE TABLE #TEMP (name varchar(80) Collate SQL_Latin1_General_CP1_CI_AS) INSERT INTO #TEMP values ('Malteser Schloßschule') if you have some column datatype NVARCHAR? SQL_Latin1_General_CP1_CI_AS doesn't support Unicode and thus falls back to Latin1_General_CI_AS.Because NVARCHAR is for Unicode chnge the collation look the bellow link https://www.mssqltips.com/sqlservertip/2513/identify-sql-server-instance-and-database-collation-using-tsql-and-ssms/ //for nvarchar insert before valu place N INSERT INTO tablename (field1) VALUES (N'ABC');

Jignesh Kumar · Answer

Hi Karthik, Please take back up for you database(if anything goes wrong you can revert that version) and then try below link, https://stackoverflow.com/questions/1607560/cannot-resolve-the-collation-conflict-between-sql-latin1-general-cp1-ci-as-and https://stackoverflow.com/questions/18122773/change-collations-of-all-columns-of-all-tables-in-sql-server

Sujeet Raman · Answer

sql server

Laxmidhar Sahoo · Answer

hi my sql VS project getting collatation error From your above statement whether database is mysql or sql server