By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,378 Members | 1,385 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,378 IT Pros & Developers. It's quick & easy.

SQL Database design :- varchar datatype doubt

P: 29
hi all,


As we design a database
I have a field for storing the last name,
so i give the datatype varchar (50)

now my question is there any difference if i were use

varchar (200) instead of varchar(50)

any performance or any issues
Apr 22 '08 #1
Share this Question
Share on Google+
5 Replies


debasisdas
Expert 5K+
P: 8,127
No there won't be any difference in database.
Apr 22 '08 #2

P: 29
No there won't be any difference in database.

so isnt it a bad coding style... how can we stop someone from doing this.
May 1 '08 #3

P: 29
so isnt it a bad coding style... how can we stop someone from doing this.


I mean how can we discourage such definations with some valid arguments
May 1 '08 #4

ck9663
Expert 2.5K+
P: 2,878
Will this help?

-- CK
May 1 '08 #5

P: 29
Will this help?

-- CK
Thanks it was quite informative.
May 5 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.