SQL Database design :- varchar datatype doubt

[tim007]

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

[debasisdas]

No there won't be any difference in database.

[tim007]

No there won't be any difference in database.

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

[tim007]

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

[ck9663]

Will this help?

-- CK

[tim007]

Will this help?

-- CK

Thanks it was quite informative.