Hi,
We often ran into issues with Health checks sql queries collation issues. This time on the "Content data". Would be possible to adjust the sql queries to INFORMATION_SCHEMA.TABLES to use default database collation?
For example:
SELECT TOP 100 [PageId]
FROM [Page]
WHERE [PageItemType] > ''
AND NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = CONCAT('ItemType_', [PageItemType]))
SELECT TOP 100 [PageId]
FROM [Page]
WHERE [PageItemType] > ''
AND NOT EXISTS (
SELECT 1
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME COLLATE DATABASE_DEFAULT
= CONCAT('ItemType_', [PageItemType]) COLLATE DATABASE_DEFAULT
);
DW 9.17.8
BR Mario
