Skip to Content
Former Member
Apr 17, 2007 at 07:56 PM

B1 create User Defined Field as nvarchar(max) in SQL 2005 database


Hi everyone,

I just created a UDF in B1 as alphanumeric(12), and noticed that B1 created a field in SQL 2005 as nvarchar(max) instead of nvarchar(12). I tested with both 2005A SP01 patch 14 and patch 20. It always creates UDF as nvarchar(max). Is this a bug? It will cause db file use more disk space and also reduce the query performance. Also, B1 won't create the index on the UDF even if you select the option.

Thanks for help,