Title case and "search case"?!

Title case and "search case"?!

am 04.09.2007 00:21:58 von esha

I just changed some fields to Title Case as I find that convenient for
name fields and the like. Butbutbut...

Now if I search for a name I need to manually remember the initial
capitals in the search to find anything at all!?

So what's the right solution that would fullfill my need?

Best regards

:-) Esben

Re: Title case and "search case"?!

am 04.09.2007 02:33:41 von Howard Schlossberg

Searches are not case sensitive unless you have the indexing set to
Unicode instead of English or the default.

Esben wrote:
> I just changed some fields to Title Case as I find that convenient for
> name fields and the like. Butbutbut...
>
> Now if I search for a name I need to manually remember the initial
> capitals in the search to find anything at all!?
>
> So what's the right solution that would fullfill my need?

Re: Title case and "search case"?!

am 04.09.2007 09:05:34 von esha

Howard Schlossberg wrote:

> Esben wrote:
> > I just changed some fields to Title Case as I find that convenient for
> > name fields and the like. Butbutbut...
> >
> > Now if I search for a name I need to manually remember the initial
> > capitals in the search to find anything at all!?
> >
> > So what's the right solution that would fullfill my need?
>
> Searches are not case sensitive unless you have the indexing set to
> Unicode instead of English or the default.

Then Danish must be a Unicode language or...? Changed it to default and
it worked.

Problem is we've got letters nobody else uses, that FM9 need to be aware
of to sort correctly...

Seems I can't have it both ways


:-) Esben

Mail: nameasofabove_h@get2net.dk

Re: Title case and "search case"?!

am 06.09.2007 10:29:25 von ursus.kirk

"Esben" schreef in bericht
news:1i3wrsm.g2iuek1ug68inN%esha@nospamget2net.dk...
> Howard Schlossberg wrote:
>
>> Esben wrote:
>> > I just changed some fields to Title Case as I find that convenient for
>> > name fields and the like. Butbutbut...
>> >
>> > Now if I search for a name I need to manually remember the initial
>> > capitals in the search to find anything at all!?
>> >
>> > So what's the right solution that would fullfill my need?
>>
>> Searches are not case sensitive unless you have the indexing set to
>> Unicode instead of English or the default.
>
> Then Danish must be a Unicode language or...? Changed it to default and
> it worked.
>
> Problem is we've got letters nobody else uses, that FM9 need to be aware
> of to sort correctly...
>
> Seems I can't have it both ways
>
>
> :-) Esben
>
> Mail: nameasofabove_h@get2net.dk

You could also try to create a calculation of the original and make this
vissible, but allways search in the original field (by way of a script if
needed, or by way of a separate search layout)

Keep well, Ursus