If I understand correctly, you have to define a char field as binary if you want the
database to treat it as a 'case sensitive' field. Is there any way via a SQL query to
force case sensitivity to be used for a non-binary char field? i.e.: for comparing
strings in a case sensitive way. Or
Hi Richard,
Richard Bolen wrote:
If I understand correctly, you have to define a char field as binary if you want the
database to treat it as a 'case sensitive' field. Is there any way via a SQL query
to force case sensitivity to be used for a non-binary char field? i.e.: for
comparing
On 22 May 2002, at 14:52, Richard Bolen wrote:
Is there any way via a SQL query to force case sensitivity to be
used for a non-binary char field? i.e.: for comparing strings in a
case sensitive way.
SELECT * FROM users WHERE BINARY password = 'cAsE_MAttErS';