My Oracle Support Banner

Timesten: Is it Possible to Perform Case-Insensitive Searches in Queries? (Doc ID 1097275.1)

Last updated on FEBRUARY 14, 2022

Applies to:

Oracle TimesTen In-Memory Database - Version to [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.

*** ***


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

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