Gossamer Forum
Home : Products : Gossamer Links : Pre Sales :

Case SenSiTive searches

Quote Reply
Case SenSiTive searches
Does Links SQL have case sensitive searching as a feature?
I need it for DBMan SQL and the query subroutines are very similar. I was hoping to add that to my subroutine.

Quote Reply
Re: Case SenSiTive searches In reply to
Not built-in...may be with the next release...but no gaurantee.

Regards,

Eliot Lee
Quote Reply
Re: Case SenSiTive searches In reply to
An easy way to change this is to change the type in the SQL database from CHAR(50) to BINARY(50). When you do a search on a binary field it will be case sensitive.

You won't be able to switch back and forth though.

Cheers,

Alex

--
Gossamer Threads Inc.