othmar52 / slimpd

PHP/JS based MPD-web-client for large music collections
GNU Affero General Public License v3.0
41 stars 11 forks source link

[Sphinx For Cyrillic] add Cyrillic data to sphinx and Search Form #67

Closed filatovvo closed 6 years ago

filatovvo commented 6 years ago

ScreenShot1 ScreenShot2

othmar52 commented 6 years ago

I can confirm the issue in screenshot2 and i have no idea why sphinx does not handle those characters correctly

othmar52@machine ~ $ mysql -P9306 --protocol=tcp

mysql> SELECT itemuid,artist FROM slimpdmain WHERE itemuid=1178169;
+---------+--------------+
| itemuid | artist       |
+---------+--------------+
| 1178169 | 細野晴臣     |
+---------+--------------+
1 row in set (0,00 sec)

mysql> SELECT * FROM slimpdmain WHERE MATCH('@artist "細野晴臣"');
Empty set (0,01 sec)

regarding to sphinxforum the charset_table configuration of sphinx has to be extended!?

In general it would be great to add a short description to opened issues instead of limiting to screenshot-links. Further one single task/bug/whatever per issue would be great :)

filatovvo commented 6 years ago

In general it would be great to add a short description to opened issues instead of limiting to screenshot-links. Further one single task/bug/whatever per issue would be great :)

I`ll give a try ;)

I`m pulling master branch now after pull request, then i try to clean rescan all my library for testing last your commits

filatovvo commented 6 years ago

Your commit 9f28a64 not enough

@see #70

filatovvo commented 6 years ago

Now Everything is Good On This Issue

Issue Can Be closed after PR. #70

othmar52 commented 6 years ago

Thank you!