|
|
|
Cyrillic search engine
|
|||
|---|---|---|---|
|
#18+
Has anyone build proper cyrillic search engine? I have problems in doing that because when searching among latin and cyrillic data mysql accepts set of cyrillic charsets as english words. As an example when someone types: "окно" that string gets encoded and when mysql searches among articles and results: 1 or 2 english articles with top rating and then the right cyrillic articles containing word "окно". I just want to have more correct answers. Do I have to divide search into cyrrillic and latin? Thank you. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 04.02.2004, 23:05 |
|
||
|
Cyrillic search engine
|
|||
|---|---|---|---|
|
#18+
Это проблема решается следующим способом: 1) открываем my.ini 2) выставляем -- Кусок файла my.cnf (Поплыли) -- Особое внимание!!! деректива не mysqld, а mysql !!! [mysql] default-character-set = cp1251 --- Кусок файла my.cnf (Приплыли) или так .... [client] default-character-set=cp1251 character-sets-dir=c:/mysql/share/charsets [mysqld] default-character-set=cp1251 character-sets-dir=c:/mysql/share/charsets [mysql] default-character-set=cp1251 3) После этого,просто забываем про данную проблему, все будет норммальнно искаться! /MySQLdb/ ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.02.2004, 09:59 |
|
||
|
Cyrillic search engine
|
|||
|---|---|---|---|
|
#18+
Yes, you are right but, in my case I don't have access to these files. Therefore I cannot change them or whatever. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.02.2004, 15:11 |
|
||
|
Cyrillic search engine
|
|||
|---|---|---|---|
|
#18+
I've seen some new features in MySql >= 4.1 such as COLLATE which gives way of interpreting character sets. Misfortunately only few hosting-providers are supporting these functions. Thus way each database/table/column can be interpretet as having data of differrent charaterer set. so the solution can be like this: SELECT article FROM articles GROUP BY article COLLATE cyrillic_cp1251; ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 06.02.2004, 18:17 |
|
||
|
|
start [/forum/topic.php?fid=23&msg=32398866&tid=1480104]: |
0ms |
get settings: |
12ms |
get forum list: |
15ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
40ms |
get topic data: |
10ms |
get forum data: |
2ms |
get page messages: |
45ms |
get tp. blocked users: |
1ms |
| others: | 246ms |
| total: | 379ms |
| 0 / 0 |
