[AccessD] Nvarchar(max)

Stuart McLachlan stuart at lexacorp.com.pg
Fri Jul 2 01:49:07 CDT 2021


It's worth noting that Access controls can only display the first 64 000 characters of a 
LongText field, so it might be worth trying that for the NVARCHAR() size as a test case
.
--
Stuart

On 2 Jul 2021 at 6:42, Gustav Brock via AccessD wrote:

> 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> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list