Skip to Content
0
Jun 23, 2008 at 08:00 PM

nvarchar(max) vs. what was entered in Manage User Fields

19 Views

When I create alphanumeric fileds in the manager user field function, all are being created in SQL as nvarchar(max). Then off course that causes problems with other tools such as Crystal.

I have a customer running MS SQL 2005 and Patch 45, this doesn't happen. I have another customer running the same (MS SQL 2005 and PL45) and they get nvarchar(max) on all alpha field adds. They both have their collate sequence set correctly, what other setting what cause this not to happen?

Thank you for any insight