Msg 451, Level 16, State 1, Line 1
Cannot resolve collation conflict between"Latin1_General_100_CS_AS"and"Latin1_General_CI_AI"inUNIONALL operator occurring inSELECT statement column 1.
select geography::CollectionAggregate ( SpatialLocation ).ToString()
where City = 'Sydney'unionallselect SpatialLocation.ToString()
where City = 'Sydney'
Latin1_General_100_CS_AS is the database collation and the server collation is Latin1_General_CI_AS so where does Latin1_General_CI_AI come from and why would the ToString() methods return different collations?
Wednesday, July 20, 2011 1:50 PM
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.