This series is a sub-series of the Adventures with a Raspberry Pi, in which I am going to step through installing Pi-hole on a Raspberry Pi.
If you’re reading this post on azurecurve, this index will automatically update, otherwise you need to check back to the original post.
As with virtually all headlines containing a question, the short answer is no. From the research I have done, the temp table will always be created with the collation of the SQL Server. If you want to skip to the solution, click here.
Why would you want a different collation? Well, in this case we need a different collation as there is a third party database which a customisation in Microsoft Dynamics GP is using for pricing lookups. The database was originally on a server with the same collation (SQL_Latin1_General_CP1_CI_AS) as the Dynamics GP server (and which the database shares). However, the database has now been moved to a new server with the default UK server collation (Latin1_General_CI_AS).
The problem now is that when data is being inserted or updated into this database, a collation error is produced:
[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal operation.Code: 8004OE14
Source: Microsoft OLE DB Provider for ODBC Drivers
Continue reading “Can I Create a Temp Table With Collation Different to the Server Collation?”