nvarchar(max) Discussion

40 Views

Good Day

Experts:

I read all the posts on the nvarchar(max) difficulties and have a question to open up to the forum.

Hopefully someone has worked with the workaround with success. I think Owen mentioned in one post to set the DbServerType = dst_MSSQL instead of dst_MSSQL2005 before adddind UDF's.

I have a 2005 db that has, of course, been determined that when using my Auto-add function for UD tables produces the nvarchar(max) fields. So, right before I run this routine I have added the following line:

g_B1Connection.Company.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL

I run the routine again(after deleting the previously created tables) and still get the nvarchar(max).

Is there anything else I need to set with the above line to be able to run my routine without getting the nvarchar(max)?

Thanks,

Ed