varchar2

[sysdba]

Hi,

Can anyone tell me what is disadvantage of
using varchar2(4000) if varchar2(3) works?

Thanks,

[sambavan]

These questions would be more appropriate in the development forum. So I'm moving this from administration to the development forum...

Sam

[sysdba]

No disadvantage so far?

Then I will use varchar2(4000) all the time to avoid
length limitation problems.

[tamilselvan]

Let us take a practical example.
You want to define a column, city.
How many characters do you think this column will have?
Say a maximum of 40.
Then think of User Interface. Suppose if this column is displayed on the screen for user input, do you want to allocate 4000 characters or 40 characters?

Think it over and determine the length.