Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Page 1 of 2 12 LastLast
Results 1 to 15 of 23
  1. #1
    Regular Coder DELOCH's Avatar
    Join Date
    Apr 2006
    Location
    Canada
    Posts
    537
    Thanks
    4
    Thanked 2 Times in 2 Posts

    MySQL turns to lowercase

    I am seriously being bugged about the idea that everytime I make a query like:

    CREATE DATABASE `MyDatabase`
    creates a database mydatabase

    I need it to be the exact case: eg MyDatabase must be MyDatabase and mydatabase be mydatabase

    is this a bug or is MySQL actually worse than Access?

    Please Help, I can't make databases with lowercase... or uppercase.. I need mixed case

    Thanks :S

  • #2
    Senior Coder
    Join Date
    Sep 2005
    Posts
    1,791
    Thanks
    5
    Thanked 36 Times in 35 Posts
    why do you care about case?
    whenever you interact with the database it will sort itself out...

  • #3
    Regular Coder DELOCH's Avatar
    Join Date
    Apr 2006
    Location
    Canada
    Posts
    537
    Thanks
    4
    Thanked 2 Times in 2 Posts
    True but there are 3 reasons.

    1) It is harder to recognize the database I need, I use a lot of spacing and Casing thus it helps a lot

    2) One person who wanted a database from me took me extra time to go to the mysql server root, and edit the names of all the object... It is annoying

    3) It is really annoying when something doesnt do what it is suppose to and I can't do anything about it, especially when I know enough SQL

  • #4
    Regular Coder
    Join Date
    Jun 2005
    Posts
    804
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The lower_case_table_names system variable determines this behavior, but you should read this before changing it.

  • #5
    Regular Coder DELOCH's Avatar
    Join Date
    Apr 2006
    Location
    Canada
    Posts
    537
    Thanks
    4
    Thanked 2 Times in 2 Posts
    where is the ini file with that option located?

  • #6
    Regular Coder
    Join Date
    Jun 2005
    Posts
    804
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It depends. Linky.

  • #7
    Regular Coder DELOCH's Avatar
    Join Date
    Apr 2006
    Location
    Canada
    Posts
    537
    Thanks
    4
    Thanked 2 Times in 2 Posts
    I am using Windows XP how am I suppose to add case sensetivity that is all I ask, I dont use command prompt for mysql... plus it doesnt work from the way above

    sorry but... I guess i will quit mysql, I'll go get oracle... I think

  • #8
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    You can't get case sensitivity in Windows since that isn't offered by that operating system, that was in the first link given to you.

    I personally think it is a waste of time worrying about whether or not you can mix case for naming conventions. The data is what is important, not the box that it is held in.

  • #9
    Regular Coder DELOCH's Avatar
    Join Date
    Apr 2006
    Location
    Canada
    Posts
    537
    Thanks
    4
    Thanked 2 Times in 2 Posts
    yes but it is extremely uncomfortable and not tidy at all

    i always use mixed case like

    Name or
    LastName

    but name and lastname woundnt help, why is it made in this way?

  • #10
    Super Moderator
    Join Date
    May 2005
    Location
    Southern tip of Silicon Valley
    Posts
    2,947
    Thanks
    2
    Thanked 170 Times in 165 Posts
    why is it made in this way?
    Because Bill Gates doesn't believe that case sensitivity is important in his OS.

  • #11
    Regular Coder DELOCH's Avatar
    Join Date
    Apr 2006
    Location
    Canada
    Posts
    537
    Thanks
    4
    Thanked 2 Times in 2 Posts
    I mean both my Database name and Table names in mysql turn lowercase while my records are case-sensetive

    Is there a way or not, if not is there a real Database that can be case sensetive or is SQL, MySQL, Oracle, DB1/2/3(if exists)

    because I seriously got used to case sensetivity, especially while using PHP, C#, C++, Javascript, XHTML and such

  • #12
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    Are you not reading or what? MySQL is case sensitive if you were to use a brand of UNIX. MySQL is not case sensitive when you use windows since Windows does not support case sensitivity.

    because I seriously got used to case sensetivity, especially while using PHP, C#, C++, Javascript, XHTML and such
    that may be true but that would be because the editors you are using support case sensitivity. But I bet you can't save any of those files in mixed case for the file name on Windows now can you?

  • #13
    Regular Coder DELOCH's Avatar
    Join Date
    Apr 2006
    Location
    Canada
    Posts
    537
    Thanks
    4
    Thanked 2 Times in 2 Posts
    to tell you the truth I can...

    attempt: save as: MyFiLeName.php
    result: MyFiLeName.php

    I make programs with mixed case all the time like: WebBrowser(test) or TeXtEd

    sorry but I think this is what you asked... and no I will never in my life use anything but Windows and Mac... Mac looks nice(OS X)... even though I never touched a mac in my whole life ... same for Linux, and UNIX, and other OS

  • #14
    Regular Coder
    Join Date
    Jun 2005
    Posts
    804
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes, you can save MyFileName.php. Then you can refer to (or overwrite) it with myfilename.php, MYFILENAME.php, MyFileNAME.php, etc.

    The best you're going to get is to set your lower_case_table_names variable to 2, which will mirror Windows behavior of displaying with case, but storing without it. The second link I posted will tell you what options you have for setting that variable, including using an options file.

  • #15
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    KidCharming, thanks for clarifying my point. Damn, I hate when I know what I'm talking about but then say something entirely different. My wife tells me I do that all the time.


  •  
    Page 1 of 2 12 LastLast

    Posting Permissions

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