My Oracle Support Banner

Differences in String Comparison Rules for TimesTen Version6 and Version7 (Doc ID 417414.1)

Last updated on APRIL 13, 2020

Applies to:

Oracle TimesTen In-Memory Database - Version 5.0.1 to 7.0.1.0.0 [Release 5.x to 7.0]
Information in this document applies to any platform.
Information in this document applies to any platform.
This Bulletin is relevant all version 7 releases of TimesTen In Memory Database

NOTE: In the images and/or the document content below, the user information, the object name information, the database name information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Purpose

TimesTen has implemented a different set string comparison rules in Version7. The changes in rules are especially significant when evaluating empty strings or substrings and may cause unexpected application behavior for customers migrating applications from earlier versions to Version 7.

Scope

The new string comparison rules are intended to make TimesTen string comparisons consistent with Oracle. In fact the pre-Version7 comparison rules matched published ASCII standards for string comparisons, which Oracle does not follow.

The "TypeMode" parameter in the datastore definition controls whether datatype semantics will conform to Oracle datatype semantics or to the semantics of previous TimesTen versions. TypeMode=0 is the default and is advised for all new TimesTen datastores. TypeMode=1 indicates that the datastore will use the older ascii-standard semantics; Typemode=1 should be used only for datastores which were created in earlier versions of TimesTen and which have been migrated to Version7.  

Details

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
Purpose
Scope
Details

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