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?
646 views Asked by Kris At
0
There are 0 answers
Related Questions in CJK
- Japanese (Mozc) input not working in browser created by Selenium
- Problems in displaying polyphonic Chinese characters
- HL7 encoding characters in non-ASCII strings
- Closing HTML tags insert "phantom" space in Chinese text
- Halfwidth vs Fullwidth Forms in JIS X 208
- JavaFX 21 TextField and Japanese input
- Netbeans: UTF-8 characters Chinese Japanese (CJK) text do not print in Netbeans 20 (Java MAVEN) Output window
- How to make Excel sort by a hierarchy? A to Z sort for Japanese isn't working as expected, Custom Sort is too narrow
- Dir.bat equivalent that recognises Chinese characters
- Zero-width space and <wbr> have no effect on Japanese line-breaking
- mysqldump and restore with tranditional chinese character
- How does the js Selection.modify function differentiate between words in Chinese?
- mysql and imported data in PDF::API2 .pdf file garbled
- Mismatched Character Highlighting in Chrome Browser Search
- Stop Android Studio from thinking Korean characters are typos
Related Questions in N-GRAM
- Bitextor/Bicleaner MAX_ORDER Issue
- String Matching Function Not Matching Strings Despite Threshold Set to 0
- Incorporating Phone Number Matching into Existing String based Name Matching Function
- Ideal number of <BOS> tags in N-gram Language Model
- How to count char tuples efficiently in PHP
- How does elasticsearch count tf-idf? That looks weird
- BERTopic n-gram phrases are not adjacent to each other
- Python IntelliJ style 'search everywhere' algorithm
- bigram calculation - Memory error, large file problem
- I have Dataframe Spark and I want to generate Ngrams but the way gensim bigram model does it
- Can you use perplexity to guess the language of a document?
- Summarizing n-grams efficiently in Python on big data
- Split a string in consecutive substrings of size n in R in an efficient way
- ML.NET for Predicting Next Words with Related Word
- Java heap space error when trying to create an NGram model
Related Questions in MYSQL-5.7
- Difference in result ( MySQL 5.7 vs MySQL 8.0 ) when using group_by and offset limit
- How can I use SQL to find events with overlapping durations?
- why when upgrade from mysql 5.7 to mysql8, mysql performance on mysql8 slower than mysql5.7
- Is there any performant way to run a JSON_CONTAINS query in mysql 5.7 on multiple values
- Create Mysql Storec Procedure via Python using Mysql Connector
- MySQL query results were confusing. When selected with year separately, it gives count greater than 1, but overall it is not
- On AWS RDS, why does MySQL replication break only after upgrading the replica's Engine Version from 5.7.x to 8.0.x?
- How indicies updates are executed in InnoDB mySQL 5.7?
- SUM multiple columns building column names as string in MySQL 5.7
- Mysql migration from 5.7 to 8 leads to a string and integer comparison issues in Stored Procedure
- Installing MySQL version 5.7 on ubuntu 20.04 machine
- 5 latest topics with only 1 reply
- MY SQL listing all the parent and childrens nodes with a JOIN in MY SQL 5.7
- AES_ENCRYPT and AES_DECRYPT won’t work on MySQL 5.7
- Missing illegal Collation issues after upgrading mysql5.7 to mysql8.0.3*
Related Questions in FULLTEXT-INDEX
- Fulltext index crawls stuck at has_crawl_completed 0
- Securely validating/sanitizing user input when using SQL Server's CONTAINS() predicate
- Fulltext order by id slow
- SQL fulltext search using containstable returns false match
- About mongodb text index
- MySQL fulltext search not returning all matching results
- SQL CONTAINSTABLE does not return all the expected results
- Mysql FULLTEXT MATCH score is zero, in boolean mode, even though both terms are present
- Ignore Arabic diacritical in MySql Text Indexing
- Full text search in PostgreSQL with "to_tsvector" for all columns
- How to use like query on FullText Index Column
- MySQL using MATCH AGAINST for long unique values (8.0.27)
- SQL Match Against Fulltext Index is slow when searching common terms
- SQL Server Full-Text Search not working on PDF File
- How to rewrite create full-text search index for Neo4j 4.4
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?
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)