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

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

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