Azure / Azure/azure-functions-sql-extension

SqlTrigger not working in with Azure SQL Database collated Finnish_Swedish_CI_AI

Open
#1,036 3 comments 0 reactions 1 assignee Claimed by @MaddyDev View on GitHub
bug Needs Logs P0
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.