nvarchar(max) field not updating

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

nvarchar(max) field not updating

Author

Topic

Cluster
Starting Member

2 Posts

Posted - 2009-11-30 : 10:06:00

Hi all

I'm having a problem updating a nvarchar(max) field using an As ADODB.Recordset in VB (access)

If I use nvarchar(255) the field updates no problem using

rs.Fields("TextContent") = strText

However as soon asI change the field type to nvarchar(MAX) then absolutely no data goes in the field. There is no debug in access either it just performs the task and leaves you with a set of empty fields in that table.

I'm a bit confused as I use nvarchar(255) elsewhere in my database with the same code and it works fine

Any idea whats going wrong here?

Can give more info if required

Cluster

Cluster
Starting Member

2 Posts

Posted - 2009-11-30 : 10:07:11

ps using SQL Server Express 2005 with a microsoft access front end

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-11-30 : 12:06:37

quote:
The new larger varchar(max), nvarchar(max), and varbinary(max) data types are returned as the ADO types adLongVarChar, adLongVarWChar and adLongVarBinary respectively

http://msdn.microsoft.com/en-us/library/ms130978.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources