Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

All Alpha User Fields going to SQL 2005 as nvarchar(max)

Good Day


I just noticed that in my SBO 2005 SP01 working with MS SQL 2005, that no matter how long in the UDF tool I create an alphanumeric field for (ie. 15, 20, 30), in SQL the column format is nvarchar(max) instead of char(15), char(20), char(30).

This is causing me major trouble in Crystal. I can't group by a nvarchar(max) field, nor can I link these to any other table.field.

Has anyone encountered this? Is there something that can be changed or are we doing something wrong?

I appreciate any insight you may have...



Not what you were looking for? View more on this topic or Ask a question