Tuesday, 4 December 2012

Citrix Products & Database Collation - Which are supported where?

Whenever we see issue with DB's in Citrix Support we often find an incorrect DB collation being used for the product in question. to make things more difficult there is no one CTX that has these listed so let me try to pull together some of the data scattered throughout the Citrix support and eDocs pages:

XenApp 5.0 / 6.0 / 6.5
We have no specific KB article for this but take a look at http://support.citrix.com/article/CTX124339
The suggestion here is that we are looking for the Latin1_General_CI_AS collation as we never see issues with collation when this is used. this has been verified across multiple customers and our internal environments.

XenDesktop 5.0 - 5.6FP1
Well, a little more clarity here. Its can't me more direct than http://support.citrix.com/article/CTX132285
Case sensitive Latin_General_CI_AS_KS is the only option here.

Excalibur
Getting ahead of myself? Never! I had issue in my own test environment get up and running and guess what? Wrong collation was to blame. Latin1_General_CI_AS_KS is the choice here.


Edgesight 5.3 / 5.4
Over at the eDocs at http://support.citrix.com/proddocs/topic/edgesight54/es-system-reqs-54.html we find out that that we can NOT use case intensive collation. This is our man: Latin1_General_CI_AS

Provisioning Services (PVS) 5.x, 6.x
Checking out our internal PVS environments I can confirm the default and requirement is SQL_Latin1_General_CP1_CI_AS for PVS 6.1 and let me share this too... if you upgrade from PVS 5.6 to 6.1 you may see a whole lot of blank targets in the console afterwards. The following SQL scripts followed by a reboot should sort this:

DROP INDEX [IDX_DiskLocatorSiteIdName] ON [dbo].[DiskLocator] 
ALTER TABLE [dbo].[DiskLocator]
ALTER COLUMN [diskLocatorName] VARCHAR(52) COLLATE SQL_Latin1_General_CP1_CI_AS
CREATE UNIQUE NONCLUSTERED INDEX [IDX_DiskLocatorSiteIdName] ON [dbo].[DiskLocator]
(
       [siteId] ASC,
       [diskLocatorName] ASC,
       [storeId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

Looking for more? Let me know and I'll dig them out.

No comments:

Post a Comment