Êàê èñïðàâèòü case-sensitive ïîèñê ðóññêèõ ñëîâ? Êàê èñïðàâèòü case-sensitive ïîèñê ðóññêèõ ñëîâ?
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Êàê èñïðàâèòü case-sensitive ïîèñê ðóññêèõ ñëîâ?

Started by Semionych, October 23, 2006, 11:52:53 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

Semionych

October 23, 2006, 11:52:53 PM Last Edit: October 27, 2006, 01:14:37 PM by Makc666
Äîáðûé äåíü !

Êàê èñïðàâèòü ðåãèñòðî-çàâèñèìûé ïîèñê ðóññêèõ ñëîâ ?
Cpg: 1.4.9
Php: 4.4.2
MySQL: 4.0.26

Semionych

#1
October 23, 2006, 11:59:14 PM
Quote from: Semionych on October 23, 2006, 11:52:53 PM
Добрый день !

Как исправить регистро-зависимый поиск русских слов ?
Cpg: 1.4.9
Php: 4.4.2
MySQL: 4.0.26


Кодировка utf-8

Makc666

#2
October 24, 2006, 10:44:09 AM
÷òî çíà÷èò êàê?
Êîíêðåòíåå ïðîáëåìà íåëüçÿ îïèñûâàòü?

Ó ìåíÿ ëè÷íî, âñ¸ ðàáîòàåò íîðìàëüíî.
Ñëîâà èùóòñÿ íåçàâèñèìî îò òîãî, â êàêîé êîäèðîâêå ÿ èõ íàáðàë.

È ÷òî çíà÷èò êîäèðîâêà utf-8, ãäå ýòî?

Semionych

#3
October 24, 2006, 11:45:36 AM
Quote÷òî çíà÷èò êàê?
Êîíêðåòíåå ïðîáëåìà íåëüçÿ îïèñûâàòü?

Ó ìåíÿ ëè÷íî, âñ¸ ðàáîòàåò íîðìàëüíî.
Ñëîâà èùóòñÿ íåçàâèñèìî îò òîãî, â êàêîé êîäèðîâêå ÿ èõ íàáðàë.

Ó ìåíÿ åñëè íàáðàòü â ïîèñêå, äîïóñòèì, ñëîâî "÷åðíîãîðèÿ", òî ðåçóëüòàò ïîèñêà ïóñòîé...
Åñëè íàáðàòü "×åðíîãðèÿ" (ñ áîëüøîé áóêâû) âûâîäÿòñÿ âñå ôîòîãðàôèè â îïèñàíèÿõ êîòîðûõ
âñòðå÷àåòñÿ "×åðíîãîðèÿ". Ñ àíãëèéñêèìè çàïðîñàìè, íàïðèìåð, ÷òî "orange", ÷òî "Orange" - ñ÷èòàåòñÿ
êàê îäíî ñëîâî...

QuoteÈ ÷òî çíà÷èò êîäèðîâêà utf-8, ãäå ýòî?

 íàñòðîéêàõ Coppermine ñòîèò êîäèðîâêà utf-8

Makc666

#4
October 24, 2006, 03:06:40 PM
Quote from: Semionych on October 24, 2006, 11:45:36 AM
Ó ìåíÿ åñëè íàáðàòü â ïîèñêå, äîïóñòèì, ñëîâî "÷åðíîãîðèÿ", òî ðåçóëüòàò ïîèñêà ïóñòîé...
Åñëè íàáðàòü "×åðíîãðèÿ" (ñ áîëüøîé áóêâû) âûâîäÿòñÿ âñå ôîòîãðàôèè â îïèñàíèÿõ êîòîðûõ
âñòðå÷àåòñÿ "×åðíîãîðèÿ". Ñ àíãëèéñêèìè çàïðîñàìè, íàïðèìåð, ÷òî "orange", ÷òî "Orange" - ñ÷èòàåòñÿ
êàê îäíî ñëîâî...

 íàñòðîéêàõ Coppermine ñòîèò êîäèðîâêà utf-8
Åñëè ìíå ïàìÿòü íå èçìåíÿåò, íà ýòî âëèÿåò íàñòðîéêà mysql.
Íóæíî èñêàòü â ýòîì íàïðàâëåíèè...

Semionych

#5
October 24, 2006, 09:36:54 PM
QuoteÅñëè ìíå ïàìÿòü íå èçìåíÿåò, íà ýòî âëèÿåò íàñòðîéêà mysql.
Íóæíî èñêàòü â ýòîì íàïðàâëåíèè...

Ìîæåò åñòü ó êîãî áîëåå êîíêðåòíûå ïóòè ðåøåíèÿ ?

Semionych

#6
October 27, 2006, 01:00:23 PM
Ïåðåíåñ áàçó íà mysql5...âìåñòî ðóññêèõ áóêâ ïîÿâèëèñü çíàêè âîïðîñà.
Ðåøèë ïðîáëåìó äîáàâëåíèåì ñòðî÷êè â init.inc.php:

Code Select
// Connect to database
($CONFIG['LINK_ID'] = cpg_db_connect()) || die('<b>Coppermine critical error</b>:<br />Unable to connect to database !<br /><br />MySQL said: <b>' . mysql_error() . '</b>');
@mysql_query("SET NAMES 'utf8'"); // ýòî òî, ÷òî äîáàâèë

Òåïåðü è ïîèñê ðàáîòàåò êàê íàäî...
Print
Go Up Pages1
User actions