Difference in data retrieved with full-text index search in SQL Server 2012 and SQL Server 2016
There is an issue with full-text search in SQL Server 2012 while it works fine in SQL Server 2016.
I have the following sample images showing the output of the similar query which returns data with underscore in 2016 and in other screen it doesn't return any data with underscore and that is in SQL Server 2012.
In SQL 2012
In SQL 2016
Can anyone suggest a solution for this or any reference suggesting the solution for this issue and also the explanation why this kind of behavior is seen in between these SQL Versions.
After working on finding a solution for this issue with full-text search it is identified as the work breaker .dll is been built on different versions of SQL Server with certain special characters as word breakers.
We cannot view the list of word breakers to confirm this as it is built on .dll based architecture and we can only get the paths indicating the .dll file location's. To manually add a character to this word breaker .dll, it can be very complicated and time taking process and will have to do reverse engineering with the .dll's and try to add the above mentioned "underscore" as a word breaker and recreate the .dll.
https://dba.stackexchange.com/questions/50366/sql-server-2012-full-text-search-break-word-underscore
Partial fix with reference to the above URL they were able to get the result by changing the language to Chinese (1028) and we cannot do that as it can create other issues related to synonym search using full-text.
- pyspark statistical window function keeps calculating NULL values
- sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible'
- Sum a record with its previous not-null ordered by timestamp
- Prevent redundant results in SQL query
- SQL Query in Snowflake - Calculate Days of Supply
- How can I find out what FOREIGN KEY constraint references a table in SQL Server?
- How to extract column names from SQL query using Python
- Select on self-referencing table where all chains meet a condition
- SQL query to check if a name begins and ends with a vowel
- In a join, fields with null values are not getting shown but in normal query they are
- MySQL JSON_OBJECT() datetime format
- How to find overlapping records and select the latest record?
- SQL query for returning rows with only certain values in list but not others?
- Why does my query fail to convert a varchar value to int?
- How do I insert a record into a Postgres DB based off the MAX of one column?
- How to auto insert Current DATE in SQL with Java / Hibernate
- IsDate Function in SQL evaluates invalid dates as valid
- SQL Server - Value passes ISDATE() but fails to CAST as DATE or DATETIME
- Snowflake Regex to Camel case file name
- SQL Server DATEDIFF round up the YEAR difference. How to round it down?
- Path table to HTML treeview in SQL Server
- SUM and Decimal precision
- Choosing simple products and variable products separately in WooCommerce tables
- collation conflict between "Hebrew_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"
- Separating fields in the same column
- SQL filter for same values in different columns
- Add multiple conditional values to one column
- How do I repeat a SQL query over a set of records?
- SET CONSTRAINTS ALL DEFERRED not working as expected
- SQL YEAR(GETDATE())