Does lower_case_table_names=0 really work under Windows?

[Fan Zhang]

Hi All,

Basically I want to achieve case sensitive in MySql under Windows without using the "Binary" keyword.

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. that is, where field = "ada" returns the same results as where field = "ADA", as well as, where FIELD = "AdA"...

Is it supposed to be this way, or I need to setup anything else to achieve default case sensitive under windows?

Thank you!

FZ