Geography aggregate ToString() behaviour RRS feed

  • Question

  • 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?

    Wednesday, July 20, 2011 1:50 PM