We get the following error when running one of our existing applications which has run fine before. Errors started occurring around the 15th of may.
itgenspr004
Could not load all metadata.
One or more errors occurred.
Invalid collation 'Latin1_General_100_CS_AS_SC_UTF8'.
Regards Invantive Cloud version 22.1.187-INTERNAL+3965
Thank you for reporting the issue.
A number of changes have been made in all new 22.0 and BETA-releases to improve usability of the SQL Server-driver of Invantive SQL in environments with identifier names not in the US7ASCII character set such as Turkish special characters.
Please specify the SQL Server version and type (Azure / on-premises) as a reply.
According to system logging it might concern SQL Server 12.00.6174.8 on Azure. This might be SQL Server 2014 with patches (as described on KB5014165 - Description of the security update for SQL Server 2014 SP3 GDR: June 14, 2022 - Microsoft Support). Please note that when it concerns SQL Server 2014 that mainstream support ended on July 9, 2019. In that case, we strongly recommend upgrading to a SQL Server version supported by Microsoft.
Please execute the following query on the SQL Server instance and add the list of available collations as a reply as described in Collation and Unicode support - SQL Server | Microsoft Learn and https://techcommunity.microsoft.com/t5/azure-sql-blog/introducing-utf-8-support-for-azure-sql-database/ba-p/757748 :
select *
from sys.fn_helpcollations()
The server is running Microsoft SQL Server 2014 (SP3-GDR) (KB5021037) - 12.0.6174.8 (X64)
Jan 4 2023 08:59:45
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 (Build 9600: ) (Hypervisor)
These are the available collations:
| Collation | Description |
|---|---|
| Albanian_BIN | Albanian, binary sort |
| Albanian_BIN2 | Albanian, binary code point comparison sort |
| Albanian_CI_AI | Albanian, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Albanian_CI_AI_WS | Albanian, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Albanian_CI_AI_KS | Albanian, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Albanian_CI_AI_KS_WS | Albanian, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Albanian_CI_AS | Albanian, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Albanian_CI_AS_WS | Albanian, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Albanian_CI_AS_KS | Albanian, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Albanian_CI_AS_KS_WS | Albanian, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Albanian_CS_AI | Albanian, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Albanian_CS_AI_WS | Albanian, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Albanian_CS_AI_KS | Albanian, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Albanian_CS_AI_KS_WS | Albanian, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Albanian_CS_AS | Albanian, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Albanian_CS_AS_WS | Albanian, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Albanian_CS_AS_KS | Albanian, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Albanian_CS_AS_KS_WS | Albanian, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Albanian_100_BIN | Albanian-100, binary sort |
| Albanian_100_BIN2 | Albanian-100, binary code point comparison sort |
| Albanian_100_CI_AI | Albanian-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Albanian_100_CI_AI_WS | Albanian-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Albanian_100_CI_AI_KS | Albanian-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Albanian_100_CI_AI_KS_WS | Albanian-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Albanian_100_CI_AS | Albanian-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Albanian_100_CI_AS_WS | Albanian-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Albanian_100_CI_AS_KS | Albanian-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Albanian_100_CI_AS_KS_WS | Albanian-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Albanian_100_CS_AI | Albanian-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Albanian_100_CS_AI_WS | Albanian-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Albanian_100_CS_AI_KS | Albanian-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Albanian_100_CS_AI_KS_WS | Albanian-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Albanian_100_CS_AS | Albanian-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Albanian_100_CS_AS_WS | Albanian-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Albanian_100_CS_AS_KS | Albanian-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Albanian_100_CS_AS_KS_WS | Albanian-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Albanian_100_CI_AI_SC | Albanian-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Albanian_100_CI_AI_WS_SC | Albanian-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Albanian_100_CI_AI_KS_SC | Albanian-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Albanian_100_CI_AI_KS_WS_SC | Albanian-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Albanian_100_CI_AS_SC | Albanian-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Albanian_100_CI_AS_WS_SC | Albanian-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Albanian_100_CI_AS_KS_SC | Albanian-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Albanian_100_CI_AS_KS_WS_SC | Albanian-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Albanian_100_CS_AI_SC | Albanian-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Albanian_100_CS_AI_WS_SC | Albanian-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Albanian_100_CS_AI_KS_SC | Albanian-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Albanian_100_CS_AI_KS_WS_SC | Albanian-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Albanian_100_CS_AS_SC | Albanian-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Albanian_100_CS_AS_WS_SC | Albanian-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Albanian_100_CS_AS_KS_SC | Albanian-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Albanian_100_CS_AS_KS_WS_SC | Albanian-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Arabic_BIN | Arabic, binary sort |
| Arabic_BIN2 | Arabic, binary code point comparison sort |
| Arabic_CI_AI | Arabic, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Arabic_CI_AI_WS | Arabic, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Arabic_CI_AI_KS | Arabic, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Arabic_CI_AI_KS_WS | Arabic, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Arabic_CI_AS | Arabic, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Arabic_CI_AS_WS | Arabic, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Arabic_CI_AS_KS | Arabic, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Arabic_CI_AS_KS_WS | Arabic, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Arabic_CS_AI | Arabic, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Arabic_CS_AI_WS | Arabic, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Arabic_CS_AI_KS | Arabic, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Arabic_CS_AI_KS_WS | Arabic, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Arabic_CS_AS | Arabic, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Arabic_CS_AS_WS | Arabic, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Arabic_CS_AS_KS | Arabic, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Arabic_CS_AS_KS_WS | Arabic, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Arabic_100_BIN | Arabic-100, binary sort |
| Arabic_100_BIN2 | Arabic-100, binary code point comparison sort |
| Arabic_100_CI_AI | Arabic-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Arabic_100_CI_AI_WS | Arabic-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Arabic_100_CI_AI_KS | Arabic-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Arabic_100_CI_AI_KS_WS | Arabic-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Arabic_100_CI_AS | Arabic-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Arabic_100_CI_AS_WS | Arabic-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Arabic_100_CI_AS_KS | Arabic-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Arabic_100_CI_AS_KS_WS | Arabic-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Arabic_100_CS_AI | Arabic-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Arabic_100_CS_AI_WS | Arabic-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Arabic_100_CS_AI_KS | Arabic-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Arabic_100_CS_AI_KS_WS | Arabic-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Arabic_100_CS_AS | Arabic-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Arabic_100_CS_AS_WS | Arabic-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Arabic_100_CS_AS_KS | Arabic-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Arabic_100_CS_AS_KS_WS | Arabic-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Arabic_100_CI_AI_SC | Arabic-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Arabic_100_CI_AI_WS_SC | Arabic-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Arabic_100_CI_AI_KS_SC | Arabic-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Arabic_100_CI_AI_KS_WS_SC | Arabic-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Arabic_100_CI_AS_SC | Arabic-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Arabic_100_CI_AS_WS_SC | Arabic-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Arabic_100_CI_AS_KS_SC | Arabic-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Arabic_100_CI_AS_KS_WS_SC | Arabic-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Arabic_100_CS_AI_SC | Arabic-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Arabic_100_CS_AI_WS_SC | Arabic-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Arabic_100_CS_AI_KS_SC | Arabic-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Arabic_100_CS_AI_KS_WS_SC | Arabic-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Arabic_100_CS_AS_SC | Arabic-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Arabic_100_CS_AS_WS_SC | Arabic-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Arabic_100_CS_AS_KS_SC | Arabic-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Arabic_100_CS_AS_KS_WS_SC | Arabic-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Assamese_100_BIN | Assamese-100, binary sort |
| Assamese_100_BIN2 | Assamese-100, binary code point comparison sort |
| Assamese_100_CI_AI | Assamese-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Assamese_100_CI_AI_WS | Assamese-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Assamese_100_CI_AI_KS | Assamese-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Assamese_100_CI_AI_KS_WS | Assamese-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Assamese_100_CI_AS | Assamese-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Assamese_100_CI_AS_WS | Assamese-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Assamese_100_CI_AS_KS | Assamese-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Assamese_100_CI_AS_KS_WS | Assamese-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Assamese_100_CS_AI | Assamese-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Assamese_100_CS_AI_WS | Assamese-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Assamese_100_CS_AI_KS | Assamese-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Assamese_100_CS_AI_KS_WS | Assamese-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Assamese_100_CS_AS | Assamese-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Assamese_100_CS_AS_WS | Assamese-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Assamese_100_CS_AS_KS | Assamese-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Assamese_100_CS_AS_KS_WS | Assamese-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Assamese_100_CI_AI_SC | Assamese-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Assamese_100_CI_AI_WS_SC | Assamese-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Assamese_100_CI_AI_KS_SC | Assamese-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Assamese_100_CI_AI_KS_WS_SC | Assamese-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Assamese_100_CI_AS_SC | Assamese-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Assamese_100_CI_AS_WS_SC | Assamese-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Assamese_100_CI_AS_KS_SC | Assamese-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Assamese_100_CI_AS_KS_WS_SC | Assamese-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Assamese_100_CS_AI_SC | Assamese-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Assamese_100_CS_AI_WS_SC | Assamese-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Assamese_100_CS_AI_KS_SC | Assamese-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Assamese_100_CS_AI_KS_WS_SC | Assamese-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Assamese_100_CS_AS_SC | Assamese-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Assamese_100_CS_AS_WS_SC | Assamese-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Assamese_100_CS_AS_KS_SC | Assamese-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Assamese_100_CS_AS_KS_WS_SC | Assamese-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Azeri_Cyrillic_100_BIN | Azeri-Cyrillic-100, binary sort |
| Azeri_Cyrillic_100_BIN2 | Azeri-Cyrillic-100, binary code point comparison sort |
| Azeri_Cyrillic_100_CI_AI | Azeri-Cyrillic-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Azeri_Cyrillic_100_CI_AI_WS | Azeri-Cyrillic-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Azeri_Cyrillic_100_CI_AI_KS | Azeri-Cyrillic-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Azeri_Cyrillic_100_CI_AI_KS_WS | Azeri-Cyrillic-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Azeri_Cyrillic_100_CI_AS | Azeri-Cyrillic-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Azeri_Cyrillic_100_CI_AS_WS | Azeri-Cyrillic-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Azeri_Cyrillic_100_CI_AS_KS | Azeri-Cyrillic-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Azeri_Cyrillic_100_CI_AS_KS_WS | Azeri-Cyrillic-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Azeri_Cyrillic_100_CS_AI | Azeri-Cyrillic-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Azeri_Cyrillic_100_CS_AI_WS | Azeri-Cyrillic-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Azeri_Cyrillic_100_CS_AI_KS | Azeri-Cyrillic-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Azeri_Cyrillic_100_CS_AI_KS_WS | Azeri-Cyrillic-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Azeri_Cyrillic_100_CS_AS | Azeri-Cyrillic-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Azeri_Cyrillic_100_CS_AS_WS | Azeri-Cyrillic-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Azeri_Cyrillic_100_CS_AS_KS | Azeri-Cyrillic-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Azeri_Cyrillic_100_CS_AS_KS_WS | Azeri-Cyrillic-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Azeri_Cyrillic_100_CI_AI_SC | Azeri-Cyrillic-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Azeri_Cyrillic_100_CI_AI_WS_SC | Azeri-Cyrillic-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Azeri_Cyrillic_100_CI_AI_KS_SC | Azeri-Cyrillic-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Azeri_Cyrillic_100_CI_AI_KS_WS_SC | Azeri-Cyrillic-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Azeri_Cyrillic_100_CI_AS_SC | Azeri-Cyrillic-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Azeri_Cyrillic_100_CI_AS_WS_SC | Azeri-Cyrillic-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Azeri_Cyrillic_100_CI_AS_KS_SC | Azeri-Cyrillic-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Azeri_Cyrillic_100_CI_AS_KS_WS_SC | Azeri-Cyrillic-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Azeri_Cyrillic_100_CS_AI_SC | Azeri-Cyrillic-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Azeri_Cyrillic_100_CS_AI_WS_SC | Azeri-Cyrillic-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Azeri_Cyrillic_100_CS_AI_KS_SC | Azeri-Cyrillic-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Azeri_Cyrillic_100_CS_AI_KS_WS_SC | Azeri-Cyrillic-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Azeri_Cyrillic_100_CS_AS_SC | Azeri-Cyrillic-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Azeri_Cyrillic_100_CS_AS_WS_SC | Azeri-Cyrillic-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Azeri_Cyrillic_100_CS_AS_KS_SC | Azeri-Cyrillic-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Azeri_Cyrillic_100_CS_AS_KS_WS_SC | Azeri-Cyrillic-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Azeri_Latin_100_BIN | Azeri-Latin-100, binary sort |
| Azeri_Latin_100_BIN2 | Azeri-Latin-100, binary code point comparison sort |
| Azeri_Latin_100_CI_AI | Azeri-Latin-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Azeri_Latin_100_CI_AI_WS | Azeri-Latin-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Azeri_Latin_100_CI_AI_KS | Azeri-Latin-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Azeri_Latin_100_CI_AI_KS_WS | Azeri-Latin-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Azeri_Latin_100_CI_AS | Azeri-Latin-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Azeri_Latin_100_CI_AS_WS | Azeri-Latin-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Azeri_Latin_100_CI_AS_KS | Azeri-Latin-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Azeri_Latin_100_CI_AS_KS_WS | Azeri-Latin-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Azeri_Latin_100_CS_AI | Azeri-Latin-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Azeri_Latin_100_CS_AI_WS | Azeri-Latin-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Azeri_Latin_100_CS_AI_KS | Azeri-Latin-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Azeri_Latin_100_CS_AI_KS_WS | Azeri-Latin-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Azeri_Latin_100_CS_AS | Azeri-Latin-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Azeri_Latin_100_CS_AS_WS | Azeri-Latin-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Azeri_Latin_100_CS_AS_KS | Azeri-Latin-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Azeri_Latin_100_CS_AS_KS_WS | Azeri-Latin-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Azeri_Latin_100_CI_AI_SC | Azeri-Latin-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Azeri_Latin_100_CI_AI_WS_SC | Azeri-Latin-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Azeri_Latin_100_CI_AI_KS_SC | Azeri-Latin-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Azeri_Latin_100_CI_AI_KS_WS_SC | Azeri-Latin-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Azeri_Latin_100_CI_AS_SC | Azeri-Latin-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Azeri_Latin_100_CI_AS_WS_SC | Azeri-Latin-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Azeri_Latin_100_CI_AS_KS_SC | Azeri-Latin-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Azeri_Latin_100_CI_AS_KS_WS_SC | Azeri-Latin-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Azeri_Latin_100_CS_AI_SC | Azeri-Latin-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Azeri_Latin_100_CS_AI_WS_SC | Azeri-Latin-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
Een verbetering is doorgevoerd in releases 22.0.630 en later voor verbeterde compatibiliteit met SQL Server 2014 SP3. Deze release zal naar verwachting binnen enkele dagen in productie genomen zijn.
Het gebruik van SQL Server 2014 blijft echter afgeraden; de support hierop door Microsoft is verlopen en bij problemen in combinatie met deze versie is er een kans dat Invantive hier geen aanpassingen voor wil maken. Als alternatief kan overwogen worden het laden via een ander product te doen zoals Azure Data Factory als Microsoft daarvan de compatibiliteit met SQL Server 2014 wel wil garanderen.
Een nieuwe release is in productie genomen die dit probleem zou moeten oplossen in combinatie met SQL Server 2014 SP3.
Deze vraag is automatisch gesloten na 2 weken inactiviteit. Het laatste gegeven antwoord is gemarkeerd als oplossing.
Gelieve een nieuwe vraag te stellen via een apart topic als het probleem opnieuw optreedt. Gelieve in de nieuwe vraag een link naar dit topic op te nemen door de URL er van in de tekst te plakken.