Timesten: Is it Possible to Perform Case-Insensitive Searches in Queries?
(Doc ID 1097275.1)
Last updated on APRIL 13, 2020
Applies to:Oracle TimesTen In-Memory Database - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 7.0 to 11.2]
Information in this document applies to any platform.
This Note will be of interest to all developers writing application code for TimesTen.
***Checked for relevance on 20-03-2013***
***Checked for relevance on Oct 17, 2011***
NOTE: The data used below are not actual PRODUCTION or Customer Data, they are Oracle supplied sample tables/data.
They are being used ONLY to demonstrate the problem discussed in this note.
Is it possible to do case-insensitive searches in TimesTen? For example: given the following query
TimesTen will return
"KingJames", "kingjames", "Kingjames", "KINGJAMES"
but will not return
"JAMES", "king James", "king", "JamesKing", etc.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document