Interesting DB behaviour?

[eluser]christatedavies[/eluser]
Hi there.

I am using CI db classes to do updates, but I am a bit confused by the bahaviour.

On Linux and Mac, I would expect the table/fieldnames to be case sensitive, however, this code:

Code:

$this->db->set('fieldname', $value)->update('tablename');

works, even if I miss-type the field name with a mix of cases, when the actual field name is all lowercase.

Is this by design?

[eluser]Narf[/eluser]
UNIX-based operating systems typically have case-sensitive file systems, but that has nothing to do with databases. Most databases would have an option to enable case-sensitivity, if they support both behaviors. By default though, it would be turned off and this has nothing to do with CodeIgniter.