Hi, when I use UPPER function on DBF database to create an index I get an exception:
java.sql.SQLException: Failed to insert a new record into table ###:Failed to insert new record into table ### because of duplicate key or corrupted index file:An unknown error when insert: keyLength is 40 but the value length is 41
My example is german character "ß" that is converted to "ss" and changes the length of the field. I'm using Spring JPA and Hibernate as database connection with charSet=Cp1252 in url property. Currently I don't see any other character that is affected.
Specification-Title: HXTT DBF JDBC 4.3 Package
Specification-Version: 7.0.028 on August 29, 2019
Do you see any chance to get that issue fixed?
Fixed. It will be upload in 2 hours.