Case-sensitive (Match Case) Searching

[Andreiii]

I use Search Method 2. The results are case-sensitive...

How can I find "AAA" by typing "aaa" ?

Thanks.

[Andreiii]

Has somebody solved this problem? Very necessary.

[Andreiii]

Hello! I found that searching returns results non case-sensitive for tags area. But it still case-sensitive for content area. Help

I would like searching "Word" by typing "word", and "word" by typing "Word".

[Andreiii]

Any ideas?

[ShanePike]

I just checked my own site, and the search is complete case-insensitive. Maybe that was changed somewhere between 9.7 and 9.9?

[Andreiii]

Originally Posted by ShanePike

I just checked my own site, and the search is complete case-insensitive. Maybe that was changed somewhere between 9.7 and 9.9?

Thanks! I found that the problem exists only with russian characters. In english everything is ok.

Where should I search the difference, what should I fix?

[ShanePike]

Originally Posted by Andreiii

Thanks! I found that the problem exists only with russian characters. In english everything is ok.

Where should I search the difference, what should I fix?

I wonder if this is a function of MySQL and not Pligg. I'm not sure at all, but it feels like it might be.

In libs/search.php, I added this code on line 119:

echo 'SQL [' . $this->sql . ']';

It may be on a different line in your version of Pligg, but it's right after the if($this->searchTerm == "") block. What it does is output the SQL that's being executed to return the search results. That might give you a clue as to whether it's the way that Pligg is building the query or whether it's the way that MySQL is executing the query.

[Andreiii]

libs/search.php:

		if($this->searchTerm == ""){
			// like when on the index or upcoming pages.
			$this->sql = "SELECT link_id $from_where $search_clause $this->orderBy LIMIT $this->offset,$this->pagesize";
		}else{
			$this->sql = "SELECT link_id, link_date, link_published_date $from_where $search_clause ";
		}
		echo 'SQL [' . $this->sql . ']';
		$this->countsql = "SELECT count(*) $from_where $search_clause";

		return;

It showed me the following on the top of site:

SQL [SELECT link_id, link_date, link_published_date FROM pligg_links WHERE link_status!='discard' AND (link_url LIKE '%нарвские%' OR link_url_title LIKE '%нарвские%' OR link_title LIKE '%нарвские%' OR link_content LIKE '%нарвские%' OR link_tags LIKE '%нарвские%' ) ]

by typing нарвские

MySQL or Pligg?

[ShanePike]

Originally Posted by Andreiii

It showed me the following on the top of site:

SQL [SELECT link_id, link_date, link_published_date FROM pligg_links WHERE link_status!='discard' AND (link_url LIKE '%нарвские%' OR link_url_title LIKE '%нарвские%' OR link_title LIKE '%нарвские%' OR link_content LIKE '%нарвские%' OR link_tags LIKE '%нарвские%' ) ]

by typing нарвские

MySQL or Pligg?

Because it's just taking what you typed in and passing it along to MySQL, it looks like a function of MySQL. Reading up on Character Sets and Collations in MySQL, it looks like some language collations are case-sensitive -- which I'm assuming is the case here.

I'm not sure at all how you change that (or even if you can change it), but that link should be a good starting point for learning more.