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