Geek asks and answers

What is the difference between SQL_Latin1_General_CP1_CI_AS and SQL_Latin1_General_CP1_CI_AI

I get this error when I run an update request in Microsoft SQL Server

Unable to resolve collision conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CI_AI" in equal action.

only 2 tables are used in the query, the updated table and the temporary table into which it inserts the internal join, neither table indicated sorting, and both of them are in the same database, which means that they must have the same set as it should be the default for the database on the right

looking at sorts, the only difference is the last character, all I understand in the last part is that CI stands for Case Insensitive. if I were to strike in the dark, I would think that AI means Auto Increment, but I don't know what AS means for

+5
source share
1 answer

AI means accent, insensitive (i.e. determines if cafe = cafe). You can use the collate keyword to convert one (or both) value matches.
See the link for more information: http://msdn.microsoft.com/en-us/library/aa258237(v=sql.80).aspx

Example:

select * from r
left outer join hr on hr.name = r.name COLLATE SQL_Latin1_General_CP850_CI_AI
+11
source

More articles:


All Articles