Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,194,092 members, 7,953,328 topics. Date: Thursday, 19 September 2024 at 02:23 PM |
Nairaland Forum / Science/Technology / Programming / Mysql Lower Case Table Names (3821 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)
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: A good start . |
(1) (Reply)
Localhost Not Allowed To Connect To MySQL. Help!!!! / I'm About To Start Applying For Remote Jobs. Any Tips? / Please Note Only For Programmers..
(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. 11 |