Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,152,738 members, 7,817,033 topics. Date: Saturday, 04 May 2024 at 12:04 AM

Mysql Lower Case Table Names - Programming - Nairaland

Nairaland Forum / Science/Technology / Programming / Mysql Lower Case Table Names (3775 Views)

Create A Custom Android App At Lower Cost / Retrieving/selecting A Particular Number Of Random Rows From A Database Table / Porting PHP/MYSQL Applications to Micro-Controller Based Devices (2) (3) (4)

(1) (Reply) (Go Down)

Mysql Lower Case Table Names by javalove(m): 10:56am On Oct 22, 2008
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?
Re: Mysql Lower Case Table Names by logica(m): 11:20am On Oct 22, 2008
dude just change the names in ur code to lower-case. that's about the only way 2 handle it.
Re: Mysql Lower Case Table Names by javalove(m): 11:29am On Oct 22, 2008
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.
Re: Mysql Lower Case Table Names by logica(m): 12:26pm On Oct 22, 2008
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.
Re: Mysql Lower Case Table Names by javalove(m): 6:40pm On Oct 22, 2008
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
Re: Mysql Lower Case Table Names by japro: 10:27pm On Oct 27, 2008
. Thanks.
Re: Mysql Lower Case Table Names by javaprince(m): 11:58am On Oct 29, 2008
japro:

This is off topic but Thank goodness, i 've seen ur post in nairaland n naijadukes. Iam a newbie , i could not register my self @ naijaduke please help me on that and i need ur 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 ur guildiance javalove. My mail is morexwell@hotmail.com.08052724800. Thanks.

A good start cheesy.

(1) (Reply)

Expert Systems With Visual Basic / Official thread for C programming / Python Program Problem

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 10
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.