Geography aggregate ToString() behaviour

20 กรกฎาคม 2554 13:50

0
Not sure if this is a bug or not but I'm curious.

I've attached the AdventureWorks2008R2 data file from CodePlex. http://msftdbprodsamples.codeplex.com/releases/view/55330, to my CTP3 instance

I get this error when I run the query below
```
Msg 451, Level 16, State 1, Line 1
Cannot resolve collation conflict between "Latin1_General_100_CS_AS" and "Latin1_General_CI_AI" in UNION ALL operator occurring in SELECT statement column 1.
```
```
select geography::CollectionAggregate ( SpatialLocation ).ToString() 
from Person.Address 
where City = 'Sydney'
union all 
select SpatialLocation.ToString() 
from Person.Address 
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?
Andrew