score:0
Accepted answer
You can update the collation for the table. Here are the steps to do so:
- In SQL server management studio, right click on the database in question and choose properties.
- In the properties dialogue box, choose "Options" in the left pane
- In the right pane, the current collation will be listed against Collation label.
- Change to desired and apply.
PS: Ensure all components accessing the database are stopped while doing the above. Failing this will cause an error to pop-up.
Here is where I found this information (2nd to last thread): http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=77212
More questions
- How to fix a collation conflict in a SQL Server query?
- SQL Server 2008 Collation conflict - how to resolve?
- Collation conflict using 2 versions of SQL Server
- collation conflict sql server
- Collation conflict in SQL Union All Query
- SQL Server Collation Conflict
- MS SQL Collation Conflict Latin1_General_CI_AS Linked Server
- SQL Cannot resolve the collation conflict between "Arabic_100_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation
- Collation conflict SQL Server 2008
- collation conflict SQL Server varchar stored procedure parameters
- SQL SERVER – Cannot resolve collation conflict for equal to operation
- SQL Collation conflict
- COLLATION Conflict For Equal To Operation Sql Server 2000
- Cannot resolve collation conflict for column 3 in SELECT statement in SQL Server 2014
- Collation conflict in SQL
- SQL Server Collation conflict - creating a view
- SQL Server - Select Query - Inner Join - Error message: Cannot resolve the collation conflict
- Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation
- How to Use UTF-8 Collation in SQL Server database?
- Cannot Resolve Collation Conflict
- Changing SQL Server collation to case insensitive from case sensitive?
- Temp Table collation conflict - Error : Cannot resolve the collation conflict between Latin1* and SQL_Latin1*
- Find non-default collation on columns for all tables in SQL Server
- SQL Server error "Implicit conversion of because the collation of the value is unresolved due to a collation conflict."
- SQL Server - Convert varchar to another collation (code page) to fix character encoding
- What collation to use for SQL Server database?
- Choosing a binary collation that can differentiate between 'ss' and 'ß' for nvarchar column in Sql Server
- SQL Server Collation Choices
- Complications with SQL Server database having different collation than the server default?
- Cannot resolve the collation conflict between "SQL_Latin1_General_Pref_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation
More questions with similar tag
- How to check if last record has been reached
- how to read data from a table in database and insert into another database?
- Insert data into one column from two other columns of the same table
- Return correct records with TSQL JOIN
- SQL Server: copy, replace and paste within same table
- Selecting max record for each user
- How to find all objects in a database that use UNION
- SSRS Report Development for D365 - Dynamics 365 Report Authoring Extension is not Getting Installed
- SQL: SELECT if entry in one column corresponds to another column of a different table
- SQL Server Error - HRESULT E_FAIL has been returned from a call to a COM component
- how to: retrieve values from database only when they are updated
- Parse Columns in SQL by delimiter
- Grouping SQL columns from one table
- SQL add Foreign key constraint with check
- Invalid Column Name in Select Statement
- Is there a decent technique for SSIS Derived Column date formatting?
- How to resolve collation conflicts with the Entity Framework?
- Filtering a group of records
- Default value for char/varchar in SQL column: space(1) or empty string?
- In SQL Server 2012, how do I get the column name and data type from a view, function, or stored procedure?
- How to optimize query that has the same subquery twice?
- How to create a nullable record in SQL Server 2008 R2?
- T-SQL Select all from TableA and condition on TableB
- Unable to serialize the session state
- multipe group by, count and join
- Inserting to TYPE Table is so slow
- SQL query to print each character of a string : SQL server
- MSSQL function to convert string to valid JSON
- How to concatenate data from a SQL Server XML query?
- Distributed Transactions: .NET Framework vs .NET Core
Source:
stackoverflow.com