SQL case sensitive

timothy.ward@[removethis]hsl.gov.uk (Tim Ward)

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

SQL case sensitive

I'm having a problem with case-sensitity in a TQuery under Delphi 2.
The SQL:

select * from "mytable.db" MT
where MT."Trend" like "%sometext%"

(Trend is a memo field)

will find examples of 'sometext', but not 'someText', 'SOMEText', etc.
The same SQL is not case-sensitive under Paradox 5 or Delphi 1. Is
this apparent case-sensitivity a feature of 32 BDE/Delphi, or do I
have some obscure config setting wrong? Any help appreciated.

Tim Ward
Health and Safety Laboratory, UK

Mark Smi

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:SQL case sensitive

On Fri, 08 May 1998 08:49:10 GMT, timothy.ward@[removethis]hsl.gov.uk

Quote

(Tim Ward) wrote:
> I'm having a problem with case-sensitity in a TQuery under Delphi 2.
> The SQL:

> select * from "mytable.db" MT
> where MT."Trend" like "%sometext%"

> (Trend is a memo field)

> will find examples of 'sometext', but not 'someText', 'SOMEText', etc.
> The same SQL is not case-sensitive under Paradox 5 or Delphi 1. Is
> this apparent case-sensitivity a feature of 32 BDE/Delphi, or do I
> have some obscure config setting wrong? Any help appreciated.

> Tim Ward
> Health and Safety Laboratory, UK

USe where UPPER(...) like UPPER(...). This should do the trick.

HTH,
Mark

Other Threads

1. Local SQL case sensitive LIKE operation?!

2. Local SQL case sensitive LIKE operation?!

3. SQL Case Sensitive ?

4. SQL - case sensitive searching - HOW TO TURN IT OFF?

5. Case Sensitive vs Case-InSensitive

6. BDE SQL Is Case Sensitive Only ?

7. Is SQL non case sensitive possible?

8. Case sensitive in SQL Statements??

9. SQL Server Case Sensitive Issue

10. Setting Case Sensitive option for SQL Server 7