Text only | Text with Images

coppermine-gallery.com/forum

Support => Русский (Russian) => Language Specific Support => cpg1.4.x Русский (Russian) => Topic started by: Semionych on October 23, 2006, 11:52:53 PM

Title: Êàê èñïðàâèòü case-sensitive ïîèñê ðóññêèõ ñëîâ?
Post by: Semionych on October 23, 2006, 11:52:53 PM
Äîáðûé äåíü !

Êàê èñïðàâèòü ðåãèñòðî-çàâèñèìûé ïîèñê ðóññêèõ ñëîâ ?
Cpg: 1.4.9
Php: 4.4.2
MySQL: 4.0.26
Title: Re: Как исправить case-sensitive поиск русских слов (кодир
Post by: Semionych on 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
Title: Re: Êàê èñïðàâèòü case-sensitive ïîèñê ðóññêèõ ñëîâ (êîäèð
Post by: Makc666 on October 24, 2006, 10:44:09 AM
÷òî çíà÷èò êàê?
Êîíêðåòíåå ïðîáëåìà íåëüçÿ îïèñûâàòü?

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

È ÷òî çíà÷èò êîäèðîâêà utf-8, ãäå ýòî?
Title: Re: Êàê èñïðàâèòü case-sensitive ïîèñê ðóññêèõ ñëîâ?
Post by: Semionych on October 24, 2006, 11:45:36 AM
Quote÷òî çíà÷èò êàê?
Êîíêðåòíåå ïðîáëåìà íåëüçÿ îïèñûâàòü?

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

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

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

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

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

 íàñòðîéêàõ Coppermine ñòîèò êîäèðîâêà utf-8
Åñëè ìíå ïàìÿòü íå èçìåíÿåò, íà ýòî âëèÿåò íàñòðîéêà mysql.
Íóæíî èñêàòü â ýòîì íàïðàâëåíèè...
Title: Re: Êàê èñïðàâèòü case-sensitive ïîèñê ðóññêèõ ñëîâ?
Post by: Semionych on October 24, 2006, 09:36:54 PM
QuoteÅñëè ìíå ïàìÿòü íå èçìåíÿåò, íà ýòî âëèÿåò íàñòðîéêà mysql.
Íóæíî èñêàòü â ýòîì íàïðàâëåíèè...

Ìîæåò åñòü ó êîãî áîëåå êîíêðåòíûå ïóòè ðåøåíèÿ ?
Title: Re: Êàê èñïðàâèòü case-sensitive ïîèñê ðóññêèõ ñëîâ?
Post by: Semionych on 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'"); // ýòî òî, ÷òî äîáàâèë

Òåïåðü è ïîèñê ðàáîòàåò êàê íàäî...
Text only | Text with Images