Azure / Azure/azure-quickstart-templates

Microsoft.Sql/servers/databases - collation entry not supported by Azure SQL db

Open
#3,386 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Bicep
Stars
14.9k
Forks
16.2k
Avg merge
6d 21h
Merged PRs (30d)
6

Description

201-sql-database-transparent-encryption-create ([Template link](https://github.com/Azure/azure-quickstart-templates/blob/master/201-sql-database-transparent-encryption-create))

### Issue Details
In an existing Azure SQL db I use collation "SQL_Latin1_General_CP1_CI_AS" but when authoring the ARM template in VS 2017 (like the one in this quick start) i always get an irritating squiggly saying that it does not conform to the schema. But on the other hand - if I use the collation closets to the one I want (SQL_Latin1_General_Cp1_CI_AS_KI_WI) I get an deploy error (see image below)

![image](https://cloud.githubusercontent.com/assets/11940728/25407261/fabffa2e-2a09-11e7-8c49-149e393b3511.png)

If I ignore the schema violation and deploy it anyway everything work like a charm!

Tried exporting the arm template from the Azure Portal on an existing SQL DB and it seems to be sticking.

![image](https://cloud.githubusercontent.com/assets/11940728/25407523/e254f0f6-2a0a-11e7-9465-a5b4e6493a89.png)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the linked 201-sql-database-transparent-encryption-create quickstart and compare its collation entry with the existing Azure SQL database behavior described. Reproduce the VS 2017 schema warning and the deployment error for SQL_Latin1_General_CP1_CI_AS versus SQL_Latin1_General_Cp1_CI_AS_KI_WI; done means the schema and deployment behavior agree with the supported collation.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, sql
Domain
cloud, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.