diff options
| author | JPVenson <github@jpb.email> | 2025-01-27 20:55:39 +0000 |
|---|---|---|
| committer | JPVenson <github@jpb.email> | 2025-01-27 20:55:39 +0000 |
| commit | d07e1a13b315fe6ebccf5c89cacf1c8a94b13a5f (patch) | |
| tree | 2f3ac07ec9d41c684df8825f07069d55a5495998 /Jellyfin.Database | |
| parent | 74858042fce56eeb7af5cf991569fee0dca50775 (diff) | |
Fixed collation settings
Diffstat (limited to 'Jellyfin.Database')
| -rw-r--r-- | Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250127174201_InitMigration.cs | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250127174201_InitMigration.cs b/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250127174201_InitMigration.cs index f1d0d1564..01ddd5ec9 100644 --- a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250127174201_InitMigration.cs +++ b/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250127174201_InitMigration.cs @@ -12,6 +12,9 @@ namespace Jellyfin.Database.Providers.PgSql.Migrations /// <inheritdoc /> protected override void Up(MigrationBuilder migrationBuilder) { + // shim NOCASE collation with an undefined locale and case-insensitive matching rules. + migrationBuilder.Sql("CREATE COLLATION NOCASE (provider = icu, locale = 'und-x-icu.utf8', deterministic = false)"); + migrationBuilder.CreateTable( name: "ActivityLogs", columns: table => new |