Question about design practice - Address table

[topmac]

In a db, is it a good practice to have Address info in Address table in upper case or lower case?
ex: street name, city, state, county, country etc..

How about name [first name, middle name, last name, prefix, suffix....]

If you have any links that talk in detail about this, I'd like to read them too

thanks everyone,
mac

 

[yetanotherjo]

Is the database case sensitive?
How is data entry done?
How much effort do you want to put into retrieving the data in the format you want?

 

[mrdenny]

I keep the data in it's natural format. This way when customers are looking at there name it's returned in the way that they entered it.

I don't know of any reason to change the formatting of the data from one case to another for storage. If it needs to be displayed in all upper case for some reason, the client app can do that when it's being viewed.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[topmac]

thanks for your ideas guys....

I tried my best in one of our earlier meetings in my company to keep the data in its usual way ... and change it on the fly, when needed. But doesn't look likely that it'll stay that way. So I was looking for some strong points so I could make an impact in decision making.

[yetanotherjo:
1: DB is casesensitive
2: manually
3: I want the application to do all the formating work]

thanks again

 

[yetanotherjo]

Be careful of the case sensitivity where data is manually entered by data clerks: Fred de Wit <> Fred De Wit...probably not the answer you wanted but in my humble opinion, case sensitive databases can be a right royal pain when it comes to the vagueries of human data input of mixed case data.