ntext

NHibernate nvarchar/ntext truncation problem

I'm using nhibernate to store some user settings for an app in a SQL Server Compact Edition table. This is an excerpt the mapping file: <property name="Name" type="string" /> <property name="Value" type="string" /> Name is a regular string/nvarchar(50), and Value is set as ntext in the DB I'm trying to write a large amount of xml to...

OLEDB comparison problem nvarchar against ntext (SQLServer 2005)

I have table Tbl1( SomeName nvarchar(64) ) Over OLEDB I'm trying to select SELECT 1 FROM Tbl1 WHERE SomeName = ? binding 3 character unicode as parameter causes: DB_E_ERRORSINCOMMAND(0x80040E14L) "The data types nvarchar and ntext are incompatible in the equal to operator" I have already tried following input bindings: 1) ... cu...

Concatenate ntext in SQL Server 2005

Hi, I need to concatenate 2 ntext columns into one. I can't convert them to nchar, cause both contains strings longer than 4000 chars. Is there a way to do this in SQL Server 2005? ...

LINQ problems with NText, Text and Image on SQL server

Apologies up front, because this isn't a question but a solution - but it took a lot of searching to find out the answer and google wasn't much help, so I wanted to give something back to the community by providing the error and the solution to help future googlers. When using LINQ to SQL, I ran into a problem when submitting changes (t...

Modifying value of ntext column

I have a column in ntext which holds large unicode strings longer than 4000 chars in length. I need to update/modify the data of the rows of the column in sql but I have no clue how to do so. I have tried nvarchar(max) as a buffer but it truncates the data into 4000 chars. Could anyone help me give me a hint or an idea or a workround so...

replace ntext (more than 4000 characters) in sql server 2000

How to replace text in sql server 2000 in a ntext column with more than 4000 characters? conversion to nvarchar(max) does not work as it truncates values. ...