[AccessD] Nvarchar(max)

[Gustav Brock]

Hi Anita

A second thought: Is it only the use of max in nvarchar(max) that exposes the issue, or would any value of n in nvarchar(n) larger than some value also expose the issue?

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD <accessd-bounces+gustav=cactus.dk at databaseadvisors.com> På vegne af Anita Smith
Sendt: 2. juli 2021 08:12
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Nvarchar(max)

Gustav,
I have cracked open a new day and with it, a clearer head.

These are my findings:

Long story short - no matter the versions of Access and SQL server the nvarchar(max) issue persisted and always went away if I changed the field size to nvarchar(1000).

<snip>