locked
Geography aggregate ToString() behaviour

    Domanda

  • 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
    mercoledì 20 luglio 2011 13:50