A quick question on variable String

[icongroup2003]

Anyone know what is the maximum number of character that a string can hold. I am reading hugh ..... large chuck of data into a string variable. I do not want to have data lost due to insufficient space to hold data.

It is due to the system memory capacity or does it has a fixed number of character that it can accept ?

The number of words or lines I am inserting to the var is about a million plus ... or more ...

please give me a quick feedback.
thanks!

[divined]

A million characters. Sounds more like a word processing app to me. i don`t have the answer to your question though! Hope somebody else can shed some light!

[Lightning]

From MSDN:

A variable-length string can contain up to approximately 2 billion (2^31) characters.


A fixed-length string can contain 1 to approximately 64K (2^16) characters.