From 04d3175473187dcb33bb135586216a7c985a9f1b Mon Sep 17 00:00:00 2001 From: Luke Pulverenti Date: Thu, 12 May 2016 22:36:01 -0400 Subject: update name searching --- .../Persistence/SqliteItemRepository.cs | 9 +++------ 1 file changed, 3 insertions(+), 6 deletions(-) (limited to 'MediaBrowser.Server.Implementations/Persistence') diff --git a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs index 46cc5d0769..308ca90e0a 100644 --- a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs +++ b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs @@ -89,10 +89,6 @@ namespace MediaBrowser.Server.Implementations.Persistence /// /// Initializes a new instance of the class. /// - /// appPaths - /// or - /// jsonSerializer - /// public SqliteItemRepository(IServerConfigurationManager config, IJsonSerializer jsonSerializer, ILogManager logManager) : base(logManager) { @@ -2317,12 +2313,13 @@ namespace MediaBrowser.Server.Implementations.Persistence if (_config.Configuration.SchemaVersion >= 66) { whereClauses.Add("CleanName=@Name"); + cmd.Parameters.Add(cmd, "@Name", DbType.String).Value = query.Name.RemoveDiacritics(); } else { whereClauses.Add("Name=@Name"); + cmd.Parameters.Add(cmd, "@Name", DbType.String).Value = query.Name; } - cmd.Parameters.Add(cmd, "@Name", DbType.String).Value = query.Name; } if (!string.IsNullOrWhiteSpace(query.NameContains)) @@ -2335,7 +2332,7 @@ namespace MediaBrowser.Server.Implementations.Persistence { whereClauses.Add("Name like @NameContains"); } - cmd.Parameters.Add(cmd, "@NameContains", DbType.String).Value = "%" + query.NameContains + "%"; + cmd.Parameters.Add(cmd, "@NameContains", DbType.String).Value = "%" + query.NameContains.RemoveDiacritics() + "%"; } if (!string.IsNullOrWhiteSpace(query.NameStartsWith)) { -- cgit v1.2.3