sql server - text vs nvarchar
Posted on 2012-04-11
I am having a table in sql server 2005.
I will be reading a text file and insert the file details as string in to the table column.
Columun Name: InputXML
Initially, The data type of this column is "Text".
Since, I got the requirement saying that the input file may have 150k length data,
I changed the InptXML column data type to "nvarchar(max)"
Now, while running the batch, I am getting an error which says "FileGroup is Full and could not allocate space"
I was not sure if the error was comming even if the datatype was text.
I thought using nvarchar is better than text data type.
1. Why is filegroup full error is comming? and how to solve this? (Currently, I am just clearing the table each and every time, i get the error) Is there is any solution for this?
2. Is it because of nvarchar type?
3. Which data type i should use Text/ nvarchar(max).