Azure / Azure/azure-functions-sql-extension
SqlTrigger not working in with Azure SQL Database collated Finnish_Swedish_CI_AI
- Dominant language
- C#
- Stars
- 130
- Forks
- 71
- Avg merge
- 4d 8h
- Merged PRs (30d)
- 4
Description
- Azure Functions SQL Extension or Extension Bundle Version: 3.0.461
- Is this a deployed or local function: local
- What type of Database are you using? Microsoft SQL Azure (RTM) - 12.0.2000.8
Jan 3 2024 16:32:18
Copyright (C) 2022 Microsoft Corporation
- List any custom settings for your function app. This could be a custom time-out defined specifically for your database server or optional configuration that can be customized for the app defined [here](https://learn.microsoft.com/azure/azure-functions/functions-bindings-azure-sql-trigger?tabs=isolated-process%2Cportal&pivots=programming-language-csharp#optional-configuration).
Steps to Reproduce:
1. Azure SQL Database with collation Finnish_Swedish_CI_AI
2. Create table with above collation with some nvarchar and varchar columns
3. Turn on database server change tracking
4. Turn on table change tracking
5. Create function with SqlTrigger to above table
6. Run function
7. Function failes with error: Failed to check for changes in table 'Tablename' due to exception: Microsoft.Data.SqlClient.SqlException. Exception message: Cannot resolve the collation conflict between "Finnish_Swedish_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Contributor guide
Assessment
This issue has not been assessed yet.