Case Sensitive

[expired user #8442]'s profile image [expired user #8442] posted 9 years ago in General Permalink
Hey,

I was very shocked when I discovered that HeidiSQL transforms uppercases when you import (or query) a database...
This problem caused me a very big bug in a program, and costed me a whole afternoon.
I discovered that HeidiSQL transformed the uppercases to lowercases...

This is very shocking guys...

Please fix this, otherwise I am not able to use this lovely software anymore ;)
ansgar's profile image ansgar posted 9 years ago Permalink
What exactly was transformed from uppercase to lowercase? Table names? Values in a table? ...?
[expired user #8442]'s profile image [expired user #8442] posted 9 years ago Permalink
Table-names... Sorry ;)
ansgar's profile image ansgar posted 9 years ago Permalink
Ok, that's not done by HeidiSQL, but by the server. There is a variable "lower_case_table_names" controlling this silent conversion. See http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names

Please login to leave a reply, or register at first.