Fan Zhang wrote:
> Basically I want to achieve case sensitive in MySql under Windows without using the "Binary"
> keyword.
I don't think that's possible.
> I setup "lower_case_table_names=0" for MySql 4.1 under WindowsXP and restart mysqld. Now I
> see that the table names are shown in the lettercase as when they were created (before, all table
> names are shown in lowercase). However, according to MySql Manual, "Name comparisons are
> case sensitive" for lower_case_table_names=0. But when I do the select, it is still case insensitive.
The lower_case_table_names server variable is about the case sensitivity of table *names*, as in
SELECT * FROM foo;
SELECT * FROM FOO;
SELECT * FROM fOo;
not about string comparisons in WHERE clauses.
--
felix
Please use
BBCode to format your messages in this forum.