Nice to have: "Max" recognition in sql server

Testing old and new jdbc I saw that a column in sql server as
col1 nvarchar(max) is rendered in PA as longvarchar(1073741823).

It would be good if PA could at least accept col2 varchar(Max), or adummy interpreted as such.

Kind regards

Lou

This is a great idea. PostgreSQL has a similar feature, in that you can leave off the "precision" argument on a varchar to make it unlimited in length. We don't currently handle this properly either for round-trip engineering. You just end up with a large limit rather than truly unlimited.

I've filed this request as bug 1797.

-Jonathan

(Should this be a new thread?)

On a perhaps related note:

With MS JDBC driver sqljdbc4.jar and SQL Server 2008, I'm getting 'ntext' columns mapped to 'varchar(1073741823)' columns. Is there any workaround to this bug -- besides using a text editor on the generated forward-engineering SQL?