find out storage size in DB for growth string

  • Thread starter Thread starter Jonathan Woods
  • Start date Start date
J

Jonathan Woods

Hi there,

I would like to know how many storage size of nvarchar data type needs
to store in database for a growth string dynmically.

[For example] string sAccountName = "AAAAA"+"BBBBBB"+"CCCCCCCC"+......;


cmd.CommandText = "CREATE TABLE myDB.dbo.tblAccInfo(AccountName(????))

(????) mean I would like to know how many storage size exactly need to
fix in that field for sAccountName string.

How do i do for that? Any idea?

Thanks in advance.
 
Jonathan said:
Hi there,

I would like to know how many storage size of nvarchar data type needs
to store in database for a growth string dynmically.

[For example] string sAccountName = "AAAAA"+"BBBBBB"+"CCCCCCCC"+......;


cmd.CommandText = "CREATE TABLE myDB.dbo.tblAccInfo(AccountName(????))

(????) mean I would like to know how many storage size exactly need to
fix in that field for sAccountName string.

How do i do for that? Any idea?

Thanks in advance.
Click to expand...

That is usually determined by you and your business rules when designing
the application. Some companies have standards and limit the lengths of
strings for various database fields.

Laimis
 
Back
Top