Professional Web Applications Themes

Table name "case sensitivity" - MySQL

I am still quite new to MySQL, so this is definately a "newbie" question. I have loaded MySQL on my WinXP system to use as a test/development platform. Our "live" system is SUSE 10.1 Linux with MySQL. Connection between servers is simply a matter of changing the DSN name in the code (using ooRexx and Rexx/SQL for my programming). Many of the MySQL tables are being created through an automated process I developed to extract data from BTrieve databases. Some of these databases' "dictionary" files are in upper case and some in lower case (BTrieve dictionaries are basically schemas). Since ...

  1. #1

    Default Table name "case sensitivity"

    I am still quite new to MySQL, so this is definately a "newbie"
    question.

    I have loaded MySQL on my WinXP system to use as a test/development
    platform. Our "live" system is SUSE 10.1 Linux with MySQL.
    Connection between servers is simply a matter of changing the DSN name
    in the code (using ooRexx and Rexx/SQL for my programming).

    Many of the MySQL tables are being created through an automated
    process I developed to extract data from BTrieve databases. Some of
    these databases' "dictionary" files are in upper case and some in
    lower case (BTrieve dictionaries are basically schemas). Since my
    automation process simply uses the dictionary name as the table name,
    the result is that some are in upper case and some in lower case.

    I know Linux is much more case sensitive that Windows, but does anyone
    know if this is going to cause "headaches" down the road? Would I be
    better off to modify my automation script to "force" the case to be
    one or the other, and if so, which case would you recommend?

    Thanks,
    Lee


    Lee Guest

  2. #2

    Default Re: Table name "case sensitivity"

    Lee Peedin wrote: 

    It can. Table names are case sensitive in Unix but now Windows.

    Just be careful and use the same convention throughout. Which
    convention you use is up to you.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  3. #3

    Default Re: Table name "case sensitivity"

    On Fri, 27 Oct 2006 08:09:51 -0400, Jerry Stuckle
    <net> wrote:
     
    >
    >It can. Table names are case sensitive in Unix but now Windows.
    >
    >Just be careful and use the same convention throughout. Which
    >convention you use is up to you.[/ref]


    Thanks Jerry,
    I kinda suspected that. :-)

    Lee
    Lee Guest

  4. #4

    Default Re: Table name "case sensitivity"

    Lee

    Rather than mucking about with your conversion. When I ported my DB from XP
    to AIX I just set up the file /etc/my.cfg to include

    [mysqld]
    lower-case-table-names=1

    and for me this did the trick.

    Rob
    "Lee Peedin" <rr.com> wrote in message
    news:com... 
    >>
    >>It can. Table names are case sensitive in Unix but now Windows.
    >>
    >>Just be careful and use the same convention throughout. Which
    >>convention you use is up to you.[/ref]
    >
    >
    > Thanks Jerry,
    > I kinda suspected that. :-)
    >
    > Lee[/ref]


    LittleRob Guest

  5. #5

    Default Re: Table name "case sensitivity"

    On Fri, 27 Oct 2006 15:33:26 +0100, "LittleRob"
    <co.uk> wrote:
     

    Rob,
    You da man - thanks for this tip!

    Lee
    Lee Guest

  6. #6

    Default Re: Table name "case sensitivity"

    > Rather than mucking about with your conversion. When I ported my DB from XP 


    I always set it to 2 for windows, so it stores the names in a case
    sensitive manner. Windows will still not be case sensitive, though.
    Inconsistencies across platforms are easily found with unit tests and
    error logging.

    Best regards
    Dikkie Guest

Similar Threads

  1. #39657 [NEW]: The extended table-specification "database.table" creates errors
    By w dot kaiser at fortune dot de in forum PHP Bugs
    Replies: 5
    Last Post: November 28th, 09:53 AM
  2. Replies: 3
    Last Post: January 19th, 03:28 PM
  3. SQL 'LIKE" case sensitivity
    By NK in forum PHP Development
    Replies: 5
    Last Post: December 22nd, 04:10 AM
  4. Replies: 2
    Last Post: July 18th, 10:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139