1<?php 2 3/** 4 * webtrees: online genealogy 5 * Copyright (C) 2023 webtrees development team 6 * This program is free software: you can redistribute it and/or modify 7 * it under the terms of the GNU General Public License as published by 8 * the Free Software Foundation, either version 3 of the License, or 9 * (at your option) any later version. 10 * This program is distributed in the hope that it will be useful, 11 * but WITHOUT ANY WARRANTY; without even the implied warranty of 12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13 * GNU General Public License for more details. 14 * You should have received a copy of the GNU General Public License 15 * along with this program. If not, see <https://www.gnu.org/licenses/>. 16 */ 17 18declare(strict_types=1); 19 20namespace Fisharebest\Webtrees; 21 22use Illuminate\Database\Capsule\Manager; 23 24/** 25 * Database abstraction 26 */ 27class DB extends Manager 28{ 29 /** 30 * @internal 31 */ 32 public static function caseInsensitiveLikeOperator(): string 33 { 34 if (DB::connection()->getDriverName() === 'pgsql') { 35 return 'ILIKE'; 36 } 37 38 if (DB::connection()->getDriverName() === 'sqlsrv') { 39 return 'COLLATE SQL_UTF8_General_CI_AI LIKE'; 40 } 41 42 return 'LIKE'; 43 } 44} 45