Topic:

FuzzyDB

Ephesoft Version:

v3.0.x – v4.0.x

Issue:

FuzzyDB and FuzzyDB Search is not extracting or displaying the DB results correctly. Only the First letter of each value in the DB record is being extracted or displayed.

This is what you see in the WebUI:

 

FuzzyDB2

 

This is what you see in the Database Table:

FuzzyDB1

 

Root cause:

Customer’s fuzzy DB database have some column with CHAR datatype. Even though the size of columns having CHAR datatype is defined as 50, CHAR datatype’s counterpart in JAVA can hold only one character.

Due to the inconsistency in ability of storing number of charters by database CHAR data type and java CHAR data type, fuzzydb result on RV screen is showing single character for columns having CHAR data type.

 

Solution:

To cater this scenario in Ephesoft will require enhancements in its code base and a solution will be developed. For the time being, the problem can be resolved by changing the CHAR data type with VARCHAR data type as a workaround.

< Back|KB Main Page

Was this article helpful to you?

wikiadmin