nvarchar(max) data type?

[ttobler]

We are beginning a new product, and are targetting SQL Server 2005.

Reading thru the documentation, we'd like to use the nvarchar(max) datatype for open ended text strings, rather than ntext.

It did not seem I could either use this data type in the table elements in EA; I suspect because the EA version I'm using (6.1 build 790) does not have SQL 2005 support?

I did not see anything indicating any subsequent release supports this feature; Am I missing something?  If it is not supported, is there an easy way to add support, or is there any plans to adding this support in a future release?

Thanks for any responses.

--
Trent

[dom]

Partial solution :
In the "Settings / Database Datatypes" dialog, select de product "SQL Server 2000" and create a new datatype :
Datatype = nvarchar(max)
Common Type = ntext
Size : none

But I am waiting a real support of SQL Server 2005, impatiently

[«Midnight»]

As are we all. I put in a request for explicit support for SQL 2005 some time ago, but nothing as yet.

I'd suggest you file a formal feature request with Sparx on this. Perhaps another requester will add the necessary weight.

You can do this via the Support link at the top of the forum page, then use the Feature Request link on the left side menu.

David