Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

10774: sql server 2000 y unicode caracteres

Posted on 2014-10-28
2
Medium Priority
?
298 Views
Last Modified: 2014-10-29
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?
0
Comment
Question by:enrique_aeo
  • 2
2 Comments
 
LVL 49

Expert Comment

by:PortletPaul
ID: 40409670
what SQL did you use when you got that message?

and; did that message say "cannot change"  ?
0
 
LVL 49

Accepted Solution

by:
PortletPaul earned 2000 total points
ID: 40409682
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question