10774: sql server 2000 y unicode caracteres

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?
enrique_aeoAsked:
Who is Participating?
 
PortletPaulfreelancerCommented:
SQL 2000 is 14 years old already, it is time to consider upgrading.

Make absolutely certain you have backups before doing any of this.

However, it appears you can't just alter the data type  here. One workaround is to RENAME the old column to [remaksOLD] and then add a new column of type NTEXT [remarks]

Then update [remarks] with content of [remarksOLD]

Once you are satisfied all is well then the [remaksOLD] column could be removed from the table.

Make absolutely certain you have backups before doing any of this.

Also note. BOTH TEXT/NTEXT are DEPRECATED in later versions of SQL Server and when upgrading you should consider changing to VARCHAR(max)/NVARCHAR(max) instead
0
 
PortletPaulfreelancerCommented:
what SQL did you use when you got that message?

and; did that message say "cannot change"  ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.