November 1999

 

Magic Oracle Gateway Version 8.2-8.8 

 

 


Dear Developer,

We are happy to introduce Magic Oracle Gateway Version 8.2-8.8.

Magic Oracle 8.2-8.8 is a bug fix version for the Magic Oracle gateway that was provided with Magic 8.30 release.

We hope that the improved features of this gateway will make your work easier and more enjoyable.

 

General information

Bugs in Magic Oracle Gateway 8.2-8.8

A new feature of Magic Oracle Gateway 8.2-8.8

 

Bugs of Magic Oracle Gateway 8.2-8.8 (Top)

  • Bug 764129 – Numeric values are also sorted when using NLSSORT.
  • The Magic Oracle gateway crashes unpredictably in Direct SQL.

 

A new feature of Magic Oracle Gateway 8.2-8.8 (Top)

  • NLSSORT support

    NLSSORT allows an application to match character strings that follow alphabetic conventions. Normally, character strings in a WHERE clause are compared by using the character's binary values.

    Using NLSSORT in the WHERE clause allows users to work on a foreign-language Oracle client while sorting data alphabetically in their own language.

    To use this feature, add the following flag in the Database Properties\SQL\Database Information field in the Database repository:

    NLSSORT=Y

    This flag adds the NLSSORT function to all the WHERE clauses that Magic sends to the database as follows:

    NLSSORT (value) comparison_operator NLSSORT(column)

    Note: Using this flag may cause performance problems. Using this flag causes the Magic Oracle gateway to not be case sensitive.

 

 

 

Thank you,

The Magic Version 8 Team