From 403bd8b2674873955eedab1d578586ec2cebdc25 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Thu, 20 Aug 2020 23:29:54 +0200 Subject: createObjectsFromName(): add back case insensitivity when comparing names Fixes #2332 Didn't affect released versions --- src/iso19111/factory.cpp | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src') diff --git a/src/iso19111/factory.cpp b/src/iso19111/factory.cpp index 4894085e..a9d82268 100644 --- a/src/iso19111/factory.cpp +++ b/src/iso19111/factory.cpp @@ -5642,7 +5642,7 @@ AuthorityFactory::createObjectsFromNameEx( sql += "AND deprecated = 1 "; } if (!approximateMatch) { - sql += "AND name = ? "; + sql += "AND name = ? COLLATE NOCASE "; params.push_back(searchedNameWithoutDeprecated); } if (d->hasAuthorityRestriction()) { @@ -5672,7 +5672,7 @@ AuthorityFactory::createObjectsFromNameEx( sql += "AND ov.deprecated = 1 "; } if (!approximateMatch) { - sql += "AND a.alt_name = ? "; + sql += "AND a.alt_name = ? COLLATE NOCASE "; params.push_back(searchedNameWithoutDeprecated); } if (d->hasAuthorityRestriction()) { -- cgit v1.2.3