Our company's standard collation for all new servers and subsequent databases is
SQL_Latin1_General_CI_AS. We purchased a 3rd party software package that creates a database using the collation
Latin1_General_CI_AS. From the little information I could find on the web and books online, they seem to be the same in definition of specification; however, when joining
tables from our downstream databases to the 3rd party database tables we encounter collation errors. Our DBA insists there is no difference between the two, but the 3rd party company has informed us that their product is only certified on the collation
installed and, if we change the collation, they will no longer support the product if we have a problem them deem is related to the non-certified collation. Where can I definitively ascertain information about whether the application will behave differently
under our default collation and preclude us from using it. Thanks in advance.
View Complete Post