More Collation support + ability to set via the Portal
Right now according to the documentation the only options for collation on SQL Data Warehouse are "The default collation is SQLLatin1GeneralCP1CIAS. The other collation option is Latin1General100CIASKS_WS."
We run Latin1GeneralCI_AS which I suspect a large amount of UK customers would do. This is a supported Collation as per SQL Azure which we are migrating our operational datastore to but we can't move our data warehouse because of this. Also like SQL Azure can we have this as an option via the management portal when we create a DW.
SQLDW introduced support for over 3800 collations a while ago. I am therefore now marking this suggestion as completed. Please excuse the tardy response to your feedback.
Please refer to the following post for more information:
Thanks for the feedback!