SqlTrigger not working in with Azure SQL Database collated Finnish_Swedish_CI_AI

[jakehatinen]

• 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.

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.

[github-actions[bot]]

We need more info to debug your particular issue. If you could attach your logs to the issue, it would help us fix the issue much faster. Note that these instructions are for local development only.

1. Set the default logging level to Debug and enable logging to a file. To do this ensure the following entries are in your host.json. (instructions)

{
  "logging": {
    "fileLoggingMode": "always",
    "logLevel": {
      "default": "Debug"
    }
  }
}

2. Restart your function and reproduce your issue

3. Get the log file and attach it to this issue. By default this will be in %TMP%/LogFiles/Application/Functions/Host.

NOTE Debug logging will include information such as Database and table names, if you do not wish to include this information you can either redact it from the logs before attaching or let us know and we will provide a way to send logs directly to us.

[MaddyDev]

@jakehatinen I couldn't repro the issue on my local function on SQL 16 version. Going to try installing the specified version and try to see if I can repro the issue, meanwhile can you share logs.

[jakehatinen]

Hi, thanks for the reply.

Logs attached. Tested with table created with following:

create table TestTable ( First nvarchar(1000) collate SQL_Latin1_General_CP1_CI_AS, Second nvarchar(20) collate SQL_Latin1_General_CP1_CI_AS, Partition nvarchar(20) collate Finnish_Swedish_CI_AI, constraint PK_VendVendorPostalAddressStaging primary key (Partition, Second) )

In Azure Database db collated Finnish_Swedish_CI_AI 2024-02-27T06-38-09Z-i9.log