Just a note on changing or using Oracle case insensitivity. From what I hear, it is not usually recommended because it will significantly degrade your performance.
On Tue, Feb 7, 2012 at 10:55 AM, patchsk <[email protected]> wrote: > ** The case sensitiveness is a limitation on the database. > Oracle by default is case sensitive and you need to change its > configuration to make it case insensitive, but you need to recreate your > indices. > You can do a search on this forum for more information if it is workable. > However MS SQL server is case insensitive, so your queries would work in > either case. > With oracle I think you could use remedy FullTextSearch feature to run > case insensitive queries for specific fields. And it is free feature to use. > Otherwise as Tauf has suggested you need to convert the data to uppercase > before saving the record and any time doing a query, convert the user > entered data to uppercase to use with queries. > With the newer versions of arsystem there is a type ahead feature you can > enable case insensitive. See if it would be useful in your case. > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > -- *Tauf Chowdhury * _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
