Skip to Main Content

Special Character is last character.

LfrolioJul 20 2009 — edited Jul 22 2009
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.

L
Comments
Post Details
Added on Jul 20 2009
2 comments
2,151 views