Philippe Poelvoorde wrote:
Enrique Sanchez Vela wrote:
I would like to have MySQL differentiate between 'abc'
and 'ABC' both the server and clients. so far anything
I've done has not worked.
Is altering the column type an option ? If yes, you would change any
'text' for 'blob' and any 'varchar' for 'varchar binary', as a result
'ABC' would next be different to 'abc' (but 'i' would also be different
to 'e').
In many case using the BINARY operator in a query will suffice:
http://dev.mysql.com/doc/mysql/en/charset-binary-op.html
SELECT col1 FROM table1 WHERE BINARY col1 LIKE 'ABC%';
will only find rows with col1 starting with 'ABC', not with 'abc'.
If inserts, etc. need also differentiate between upper and lowercase
(and differentiate between accented and not-accented characters)
Philippes suggestion is probably the way to go.
Regards, Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
