My Oracle Support Banner

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 7.0.5.0.0 to 11.2.1.5.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***


Goal

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.

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.