find out storage size in DB for growth string

[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.

 

[laimis]

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.

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