Taking to dev...
On 01/02/2010, at 7:31 PM, Andrus Adamchik wrote:
> MySQL is "special" as always:
>
> http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html
Yep, also see:
http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html#function_convert
So it's easy enough to force case-sensitive comparisons using the binary keyword, but going the other way is more problematic. i.e., sure you can do a select to find the default collation for the database but this is not really good enough. This can be overridden per table and then again per column.
Thoughts Andrus?
(This is relevant discussion for CAY-1210).
with regards,
--Lachlan Deck
This archive was generated by hypermail 2.0.0 : Mon Feb 01 2010 - 14:39:43 EST