I have a table named 'comp' with a column 'compName', the compName contain different country's Characters, I am using mysql5.7 with ngram parser, now it is fine to search the Chinese word, but the it brings me the bad result when i searched English word. According to INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE table , i found it participle English word by the character, like: abc will be participled as ab,bc, But as we understand, the English will be participled as "SPACE", right ? So how to resolve this kinds of case when using ngram parser in mysql5.7.
how to fulltext index both chinese and english characters together by using ngram parser in mysql 5.7?
642 Views Asked by Kris At
0
There are 0 best solutions below
Related Questions in CJK
- Unicode Japanese prolonged sound mark excluded from Kana script?
- Chinese text encoding missing characters when viewed in web browser
- How to match chinese characters with grep?
- how to fulltext index both chinese and english characters together by using ngram parser in mysql 5.7?
- Is there a faster way of loading custom Chinese/Japanese fonts in HTML/CSS than @font-face?
- Is the Unicode Basic Multilingual Plane enough for CJK speakers?
- Using external TTF fonts to generate PDF with Japanese text using prawn
- Upload Excel file with Japanese font
- How to convert Chinese characters to Pinyin
- Weighted disjunction in Perl Regular Expressions?
- How to show alternative CJK glyphs in WIndows CE?
- Language codes for simplified Chinese and traditional Chinese?
- Can't read unicode (japanese) from a file
- Handling UTF8-encoded text in SQLite using Rose::DB::Object
- perl DBIx sqlite {sqlite_unicode=>1}?
Related Questions in N-GRAM
- Generate Random Sentence From Grammar or Ngrams?
- Saving ngram objects in a dataframe
- how to create the bigram matrix?
- elasticsearch, ngrams should cover entire query? (compound word query)
- How to assign more weight to bigram and trigram?
- Keras word embedding in four gram model
- how to fulltext index both chinese and english characters together by using ngram parser in mysql 5.7?
- Ngram Tokenizer on field, not on query
- Creating ngrams from scikit learn and count vectorizer throws Memory Error
- Create ngrams only for words on the same line (disregarding line breaks) with Scikit-learn CountVectorizer
- How to use Lingua::EN::Ngram for multiple files
- How many grams should be calculate in N-Gram model?
- Neither BigQuery nor the public data sets seems to have all the bigrams
- partial text matching in middle of word
- Detecting foreign words
Related Questions in MYSQL-5.7
- empty query after mysql upgrade from 5.5 to 5.7
- how to check whether "knownlanguages" key contains value ="English" from json datatype of mysql using query
- How to clean or resize the ibtmp1 file in MySQL?
- How to solve mysql warning: "InnoDB: page_cleaner: 1000ms intended loop took XXX ms. The settings might not be optimal "?
- Mysql Json - Fetch perticular object from json array on the basis of given id
- Which version of mysql client should I use?
- How to get parent_id using mysql query?
- How can I resolve error : Call to undefined function App\Http\Controllers\JSON_EXTRACT() in laravel 5.3?
- how to fulltext index both chinese and english characters together by using ngram parser in mysql 5.7?
- utf8mb4 encoding of csv files for import to MySQL
- How can I do update multiple rows in mysql?
- How can I do where clause containing json in mysql?
- MYSQL JSON field WHERE begins or ends with
- How to improve performance of MySQL group replication?
- How to repair the table while having small space on Hard Drive
Related Questions in FULLTEXT-INDEX
- how to fulltext index both chinese and english characters together by using ngram parser in mysql 5.7?
- MongoDB Full Text Search case-insensitive or not?
- MySQL: Best way to search in files' content (fulltext search)
- Does using FULLTEXT in MySQL require for me to use a different syntax in PHP to retrieve the results?
- FULLTEXT For Search Troubles
- SQL fulltext search using containstable returns false match
- When does full text index update in sql server?
- SQL Match Against Fulltext Index is slow when searching common terms
- MySQL using MATCH AGAINST for long unique values (8.0.27)
- How to use like query on FullText Index Column
- Negative numbers not indexed numbers without negative symbol in full text catalog
- DataBaseLock error with Django, Xapian and Haystack
- How to use CONTAINS with inline queries in SQL Server 2008?
- MySQL how to index a query that searches for a substring in column while filtering integer columns
- Does SQL Server automatically run ALTER FULLTEXT INDEX ON [table] START FULL POPULATION on its own?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?