enrique_aeo
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
and; did that message say "cannot change" ?