SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Evangelist GeekSupport's Avatar
    Join Date
    May 2002
    Location
    Southern California
    Posts
    408
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    automatically lowercase all tables/fields?

    is there a way to automatically lowercase all tables/fields? we're starting a project that will be using an msaccess database that will be converted to mysql on a weekly basis. access will be used for the office and some tables/fields will be used for online purposes. is there a way to force mysql to lowercase all the tables/fields that it creates?

  2. #2
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    MySQL is case-insensitive, can you explain why you need them all to be the same case?

  3. #3
    SitePoint Evangelist GeekSupport's Avatar
    Join Date
    May 2002
    Location
    Southern California
    Posts
    408
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    oh. i thought it was case-sensitive thinking the php script would break if i don't remember how the access admin cased the tables/fields. this makes my job a lot easier (and the only thing i make UpperCase are classes the rest are joined like_this)

  4. #4
    SitePoint Evangelist GeekSupport's Avatar
    Join Date
    May 2002
    Location
    Southern California
    Posts
    408
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    doh!
    error
    select no from local
    Table 'cft_locals.local' doesn't exist

    success
    select no from Local
    [displayed list]

    it looks like the table is case sensitive, but the field is NOT case sensitive (the field "no" is actually cased No in the Local table)


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
  •