Base Case insensitive searches?

asked 2019-11-11 10:25:28 +0100

Thunderchief gravatar image

Hi

I am converting a database from Access to Base, however I am having problems finding out how to search the data ignoring the case of the text.

Looking it up online shows that you used to have to select a table type as VARCHAR_IGNORECASE but this does not seem to be an option anymore.

can this still be done?

Thanks

edit retag flag offensive close merge delete

Comments

If you are using embedded Firebird database this might be helpful: https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-datatypes-chartypes.html#fblangref25-datatypes-chartypes-caseinsenstv . Table field type VARCHAR_IGNORECASE is a type of embedded HSQLDB, which is still available but considered deprecated.

Opaque gravatar imageOpaque ( 2019-11-11 11:38:06 +0100 )edit

The SQL LIKE operator is not case sensitive by default, so it may be of use to you.

Note that LIKE allows SQL wildcard tokens, which may need special attention in some situations (when the search term includes percent, square brackets or underscore, mostly).

See this info page about Access vs. SQL wildcards.

keme gravatar imagekeme ( 2019-11-12 13:53:12 +0100 )edit

Thanks for the ideas I will try them out.

Cheers.

Thunderchief gravatar imageThunderchief ( 2019-11-20 15:56:18 +0100 )edit