Solved

10774: sql server 2000 y unicode caracteres

Posted on 2014-10-28
2
293 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

695 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