SQL collation for Citrix products

I recently received an email asking me about which collation should be chosen for Citrix products. Here is a table of SQL collations by product. I’ll try to keep this post up to date.

Don’t hesitate to help me to improve this table.

Product Collation
XenApp (6.5) Latin1_General_CI_AS
Storefront latin1_general_CI_AS_KS
Provisionning Services SQL_Latin1_General_CP1_CI_AS
XenDesktop (5.6 to 7.1) Latin_General_CI_AS_KS.
Edgesight Latin1_General_CI_AS.
XenMobile Not found for now. PostgreSQL database automatically created with installation Wizard but possible to choose Microsoft SQL (with no other explanation on eDocs).
XenApp & XenDesktop 7.5 * Latin1_General_CI_AS_KS. Latin1_General could change depending contry. It could be Japanese_100_CI_AS_KS.
*: For XenApp & XenDesktop 7.5, Citrix recommend to enable Read-Committed Snapshot. If you build your base manually and/or mirror or make your SQL database in HA Group, see: http://support.citrix.com/article/CTX137161.
Sources : http://www.rossmccarthy.net/2013/01/citrix-products-database-collation.html, http://support.citrix.com/proddocs/topic/dws-storefront-12/dws-deploy-multi-database.html, http://support.citrix.com/proddocs/topic/xmob-dm-8/xmob-dm-install-select-components-con.html, http://support.citrix.com/proddocs/topic/xenapp-xendesktop-75/cds-install-create-site.html

Citrix, mobility & virtualization @Work / father, husband & geek @home

Tagged with: , , , , ,
Posted in Citrix
3 comments on “SQL collation for Citrix products
  1. Simon Jones says:

    Does it matter if the SQL Server collation is different to the collation of the database? If it is it means the database can’t import/export data to/from the TempDB

    • jeromequief says:

      Citrix doesn’t specify if instance collation has to be the same, but I prefer to be cautious. So, I never tried to go with different collation and I’m not sure Citrix needs TempDB. I would be interested in your tests results if you try different collations.

      • Simon Jones says:

        I had a reply from Citrix support…
        XenDesktop database MUST have collation _CI_AS_KS i.e. Case Insensitive, Accent Sensitive, Kana Sensitive Ideally the SQL Server (instance) would have the same collation as all user databases BUT this is not always possible – so it is supported even when Collations don’t match but XD database MUST BE CI_AS_KS!

        The server collation is not that important although there might be an issue when utilizing TEMP database
        On your example your instance is _CI_AS. There will be no issues with the TEMP database as the instance is Case Insensitive.

        Please let me know if you have any further queries.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: