Mysql Lower Case Table Names

Welcome. Please Login, Register, Or Activate! 
type your username and password to login
Date: November 24, 2009, 03:10 AM
431600 members and 298623 Topics
Latest Member: Aladex1
Nairaland [Nigerian Forum] Home Help Search Who is currently online? Login Register
Nairaland Forum  |  Technology  |  Programming  |  Mysql Lower Case Table Names
Pages: (1) Go Down Send this topic Notify of replies
Author Topic: Mysql Lower Case Table Names  (Read 1249 views)
javalove (m)
Mysql Lower Case Table Names
« on: October 22, 2008, 10:56 AM »

Hi all

  Meeennn i need u guys help oooo. I v just finished a desktop app and it needs to be deployed ASAP. Its a network app.

Here is me probs.

When i create my table in Mysql, it saves the names as lower case even when i use upper case. My app connects to it well on local host but when its on the network, it gives me errors.

My question,

Is there a way I can make my table names save as uppercase or mixed case on windows in mysql?
logica
Re: Mysql Lower Case Table Names
« #1 on: October 22, 2008, 11:20 AM »

dude just change the names in your code to lower-case. that's about the only way 2 handle it.
javalove (m)
Re: Mysql Lower Case Table Names
« #2 on: October 22, 2008, 11:29 AM »

well i guess dats d only option for me, my won don finish,  d code plenty oooooo

dats wai its gud to work in a team,

tnx man.
logica
Re: Mysql Lower Case Table Names
« #3 on: October 22, 2008, 12:26 PM »

no. that's why u declare constants such as names of database tables as global strings. u usually do this by having an interface which you can call "Constants" for instance. then u declare each table name like this:

public static final String TBL_NAME_1 = "table_name_1";

that way u only change the name of the table in exactly 1 location if there is a need 2 make a change.

that's good design. shikena.
javalove (m)
Re: Mysql Lower Case Table Names
« #4 on: October 22, 2008, 06:40 PM »

tnx man, funny enuf dats aw i do other stuffs ooo but neva done it for table names cos dis is d first time m facing dis probs,

tnx man
japro
Re: Mysql Lower Case Table Names
« #5 on: October 27, 2008, 10:27 PM »

This is off topic but Thank goodness, i 've seen your post in nairaland n naijadukes. Iam a newbie , i could not register my self @ naijaduke pls help me on that and  i need your asistance on JAVA CODING and software enginering. What i know how to do now is print ''WELCOME TO JAVA PROGRAMMING'' in comand window.pls i need your guildiance javalove. My mail is morexwell@hotmail.com.08052724800. Thanks.
javaprince (m)
Re: Mysql Lower Case Table Names
« #6 on: October 29, 2008, 11:58 AM »

Quote from: japro on October 27, 2008, 10:27 PM
This is off topic but Thank goodness, i 've seen your post in nairaland n naijadukes. Iam a newbie , i could not register my self @ naijaduke please help me on that and i need your asistance on JAVA CODING and software enginering. What i know how to do now is print ''WELCOME TO JAVA PROGRAMMING'' in comand window.please i need your guildiance javalove. My mail is morexwell@hotmail.com.08052724800. Thanks.

A good start Cheesy.
 Morfik: For Developing Ajax Web Applications  Which Programming Language Holds Brighter Prospects In Nigeria  Mason: A Java Json Parser That Works  Page 2
Pages: (1) Go Up Send Topic to Friend by E-mail Reply 


Sections: Autos/Cars (2) Jobs/Vacancies (2) (3) Career Talk Education General(2) Politics Romance Computers Phones Travel
Sports Fashion Health Religion Celebrities TV/Movies (2) Music/Radio (2) Books Webmasters Programming

Links: Page1 Page2 Page3 Page4 Page5 Page6 Page7 Page8 Page9 Page10

Nairaland is owned by Oluwaseun Osewa. See also: Nairalist Classified Ads
Nairaland Forum | Powered by SMF 1.0.12.
© 2001-2005, Lewis Media. All Rights Reserved.