MySQL does not support Chinese full-text indexing, how do you solve the full-text search in the construction station?

Mysql

MySQL does not support Chinese full-text indexing, how do you solve the full-text search in the construction station?

Reply to discussion (solution)

Try not to use MySQL to do full-text indexing ~ ~ ~
If a large number of searches are required, it is recommended to use Coreseek to help implement

MySQL does not support Chinese full-text indexing, how do you solve the full-text search in the construction station?

Search for this kind of thing, give it to Lucene.

Rawurlencode () Insert, search
Rawurldecode () display

Str_replace ('%20 ', ', Rawurlencode ($STR));

MySQL does not support Chinese full-text indexing, how do you solve the full-text search in the construction station?

Search for this kind of thing, give it to Lucene.
ElasticSearch?



How's hubbledotnet?

MySQL does not support Chinese full-text indexing, how do you solve the full-text search in the construction station?

Search for this kind of thing, give it to Lucene.
ElasticSearch?



How's hubbledotnet?

Let's just do something about it.

MySQL does not support Chinese full-text indexing, how do you solve the full-text search in the construction station?

Search for this kind of thing, give it to Lucene.
ElasticSearch?



How's hubbledotnet?

Let's just do something about it.
There must be a search for this feature.

Sphinx

MySQL does not support Chinese full-text indexing, how do you solve the full-text search in the construction station?

Search for this kind of thing, give it to Lucene.
ElasticSearch?



How's hubbledotnet?

Let's just do something about it.
There must be a search for this feature.


As said above, look at your needs, if you have a very large business search, then use Lucene.

If the business is small, simply point Sphinx just fine.

Mysqlcft

Lucene, ElasticSearch, more suitable for super-scale projects, small and medium performance is not good.
Hubbledotnet lacks Pishaomao. Then again, the level of attention to open source database support seems less of a priority.
coreseek/Sphinx, a typical open source product, is functionally incomplete, and the build feature is obvious.

Gave up.

