Skip to Main Content

Special Character is last character.

user11044Jul 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.

This post has been answered by kevinUCB on Jul 21 2009
Jump to Answer
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Aug 19 2009
Added on Jul 20 2009