CODEWITHSUNDEEP
phpmysqlpdofull-text-searchmatch-against
Heinz
Heinz

Reputation: 399

web aplication using php pdo fulltext search delivers result on ubuntu system but not on windows system; identical DB on both

The setting

Windows 11

Server-Version: 8.4.0 - MySQL Community Server - GPL Apache/2.4.61 (Win64) PHP/8.3.8

Ubuntu

Server-Version: 10.3.39-MariaDB-0ubuntu0.20.04.2 - Ubuntu 20.04 Apache/2.4.41 (Ubuntu) PHP-Version: 8.3.8

In phpmyadmin this sql

SELECT * FROM `search` WHERE  colname='verlag' and match(what) against( 'O\'reilly' in boolean mode);

delivers results on the Windows system and on Ubuntu allthoug teh DB-system is different.

But my web aplication on Ubuntu delivers results (>0) but in Windows none (==0)

The PHP source on both system is the same as well as the database. The collation for column what is utf8mb4_german2_ci on both systems.

$this->param->search="O'Reilly";
$this->param->colname="verlag";

$q = "select titleid as id from search where colname=? and match(what) against(? in boolean mode) ";
$ttt = $connect_pdo->prepare($q);
$ttt->execute([$this->param->colname, $this->against($this->param->search)]);

Do I have a PHP problem ?

Upvotes: 0

Views: 46

Answers (0)

Related Questions