I´m getting this error when I search the word 'áfrica' in Texis search engine.
' --Vortex Err(115): /GenericSql:322: Query `áfrica' would require post-processing: Term `áfrica' not indexable -- '
The search behaves this way every time I search words with special characters in the #1 letter of the word. Could this be some installation feature?? My OS regional settings are in Portuguese. Thanks in advance.
I've tried your command, and Texis is seeing the regional settings. I take a look at vortex.log and this is what he write's there:
115 Abr 23 12:19:57 /GenericSql:322: Query `áfrica' would require post-processing: Term `áfrica' not indexable
115 Abr 23 12:19:57 /GenericSql:322: Query 'áfrica' would require linear search
He´s not translating one char to 2, but seems to be one parsing problem.
The index expression does not match what you are searching for. Either the regional settings were not in place when you created the index, or you may need to issue the SQL: