AnsweredAssumed Answered

Oracle ESS case insensitive search

Question asked by SBerger on Aug 17, 2011
Latest reply on Oct 12, 2011 by TSGal

Summary

Oracle ESS case insensitive search

Product

FileMaker Pro

Version

11v04

Operating system version

Mac OS X 10.5.8

Description of the issue

I'm trying to do case insensitive search in FileMaker in "Name" field, that belongs to Oracle 10g  "PEOPLE" table. The only way to get results back is, if in Find mode I type  the name exactly as it was entered. Of course, I want to be able to do case insensitive search, but it doesn't work.

As per Oracle documentation, I altered two parameters in Oracle spfile :

                     nls_sort = BINARY_CI
                     nls_comp=LINGUISTIC

That should've allowed case insensitive search in database.
Am I missing something obvious?

Steps to reproduce the problem

- using actualtechnologies ODBC driver, connect to Oracle 10g.
  - define TO in FileMaker, that points to a table in Oracle.
  - create layout in FileMaker based on ESS TO.
  - enter Find mode and do search for a name.

Expected result

When I search for "john",  I expect to get "john" and "John" and "JOHN" as a result.

Actual result

Instead, I'm getting "john" only.

Configuration information

Mac OS X 10.5.8
FileMaker pro Advanced 11.v04
Oracle 10g Express
Actualtechnologies ODBC driver for Oracle - latest version

Outcomes