Special Character is last character.
Greetings All, I am running Oracle 11g and I am leveraging Oracle Text. I understand how to use printjoins and how to query via "contains". I can successfully query for a period and get back the desired result if the period is embedded mid string: e.g.) "john.paul.jones". However, when a period is the last characters: e.g.) "john.paul.jones." I cannot get the query to return the desired record. I looked in the I$ table and could not find the token "john.paul.jones.", what was there was "john.paul.jones". It seems that Oracle Text did not persist the string with the terminating period? Any and all help would be greatly appreciated.