Text field case sensitive? FM pro 8

hello,

I use a version of FM pro 8 and have recently noticed that the email
address field in filemaker is
case sensitive. For example if I search for abc@abc.org it
finds no records however if I search for ABC@abc.org it works
fine. Other fields like First Name and Last name are not case
sensitive.
Could you please suggest how I can make email addresses not be case
sensitive? Is there somehting wrong with the way Ive set the text
fields?

Thanks a ton!
Deepti

Re: Text field case sensitive? FM pro 8

On Jan 8, 3:37 am, Deepti wrote:
> hello,
>
> I use a version of FM pro 8 and have recently noticed that the email
> address field in filemaker is
> case sensitive. For example if I search for a...@abc.org it
> finds no records however if I search for A...@abc.org it works
> fine. Other fields like First Name and Last name are not case
> sensitive.
> Could you please suggest how I can make email addresses not be case
> sensitive? Is there somehting wrong with the way Ive set the text
> fields?
>
> Thanks a ton!
> Deepti

Searching on text fields is not case sensitive so there must be
something else going on. One issue is that Filemaker treats the @
symbol different than regular characters. The @ represents a single
wildcard character. Try wrapping the address in quotes, or searching
for the username and domain name with a space between instead of the
@.

And yes, it's unfortunate that FMI has stuck with a now-ubiquitous
symbol for this purpose.

Re: Text field case sensitive? FM pro 8

Deepti wrote:

> I use a version of FM pro 8 and have recently noticed that the email
> address field in filemaker is
> case sensitive. For example if I search for abc@abc.org it
> finds no records however if I search for ABC@abc.org it works
> fine. Other fields like First Name and Last name are not case
> sensitive.
> Could you please suggest how I can make email addresses not be case
> sensitive? Is there somehting wrong with the way Ive set the text
> fields?

Because of 'find' peculiarities regarding the '@' character (see Grip's
response), many developers switch the indexing for that field (in field
definitions > storage) from its default (i.e. English) to unicode or
ascii. The benefit of this is that searches with the '@' character work
properly for email fields. The downside is that it makes the finds case
sensitive.

My suggestion would be to ensure that text entered in this field is
always lowercase, so that searches will be more consistent. You can do
this by making the field an auto-enter calc (field definitions >
options) that is set to always replace itself with this calc: lower(email)

Hope that helps...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Member, FileMaker Business Alliance

Re: Text field case sensitive? FM pro 8

in email@example.org the >@< has to be escaped: email\@example.org

jens

Re: Text field case sensitive? FM pro 8

On Jan 8, 11:03 am, Howard Schlossberg
wrote:
> Deepti wrote:
> > I use a version of FM pro 8 and have recently noticed that the email
> > address field in filemaker is
> > case sensitive. For example if I search for a...@abc.org it
> > finds no records however if I search for A...@abc.org it works
> > fine. Other fields like First Name and Last name are not case
> > sensitive.
> > Could you please suggest how I can make email addresses not be case
> > sensitive? Is there somehting wrong with the way Ive set the text
> > fields?
>
> Because of 'find' peculiarities regarding the '@' character (see Grip's
> response), many developers switch the indexing for that field (in field
> definitions > storage) from its default (i.e. English) to unicode or
> ascii. The benefit of this is that searches with the '@' character work
> properly for email fields. The downside is that it makes the finds case
> sensitive.
>
> My suggestion would be to ensure that text entered in this field is
> always lowercase, so that searches will be more consistent. You can do
> this by making the field an auto-enter calc (field definitions >
> options) that is set to always replace itself with this calc: lower(email)
>
> Hope that helps...
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Howard Schlossberg
> FM Professional Solutions, Inc. Los Angeles
>
> FileMaker 8 Certified Developer
> Member, FileMaker Business Alliance

Howard: Excellent, I didn't know that about the indexing change.
Makes OP's issue make much more sense.

OP: If you do make the change to the field, afterwards, you'll have to
perform a Replace on the e-mail address field with with the calc you
just added ie Lower(email)