SQL Server 2012 Collation Error

C

CentaurusAmagmaca

The query:USE vPICList_lite;SELECT *FROM ABS runs correctly in SQL Server 2012The query:[dbo].[spVinDecode] @v = N'3VWRF81H2WM128705'returns:Msg 468, Level 16, State 9, Procedure spVinDecode, Line 282Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CPI_CI_AS" in the equal to operationIt appears that SQL Server 2012 cannot interpret a character(s), either in the string that has been entered, or in the pre-defined procedure.Note that the spVinDecode procedure was packaged with the vPICList_lite database and is meant to process the string variable on th

Continue reading...
 
Back
Top Bottom