Create a field (Number), and create-save a document with that field set.
Then create FT index for database
Then change field type from Number to text, create a new doc & save
(easily done when a field looks like it can be numeric but letters need to be added eg some unique key etc)
You can no longer search on that field because the UNK table has noted it as numeric.
Correcting this involves admin client or making a new copy of the database.. very messy, especially with large databases.
Can we have a better way of fixing this ?