Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

What do you think about case-sensitive databases? 3 Comments More | Login | Reply /

 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • The reason that database and table names are case-aware in mysql is because they're simply files and directories, and mysql punts to the underlying OS to handle it. Thus, on Windows, they're not case sensitive and on *nix they are. (BTW, I'm not defending it, I'm just pointing out why.)
    --
    (darren)

    • I know that's true for MyISAM tables, but not all storage engines store each table in individual files. Is this true for them?

      • The Views table has ENGINE=InnoDB, and the primary key is ViewID:

        mysql> select count(ViewID) from Views\G
        *************************** 1. row ***************************
        count(ViewID): 0
        1 row in set (0.00 sec)

        mysql> select count(VIEWID) from Views\G
        *************************** 1. row ***************************
        count(VIEWID): 0
        1 row in set (0.00 sec)

        mysql> select count(ViewID) from VIEWS\G
        ERROR 1146 (42S02): Table 'scimitar.VIEWS' doesn't exist

        So InnoDB behaves the same way as MyISAM on Linux. I don't know about Windows.

        --
        (darren)
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.