I have a table with records of type "text" is in a SQL Server 2000.
and a user wants to put a word in Greek and when you save it does not recognize
I've been watching and for a field recognize this data must be brought type "NVARCHAR" or "NTEXT" and to keep the prefix "N" + field, and I've tasted in a sql server 2008 and it works, the problem is that SQL Server 2000 does not allow me to change the data type "text" to "NVARCHAR" or "NTEXT"
I get: "Mens 4928, Level 16, State 1, Line 1.
You can change the 'remarks' column because it is 'text'. "
Do you think there is any other way for that field supports such values?