I explored various alternatives but could not find a different outcome. To verify, I executed a code snippet to retrieve the corresponding value for each SQL dialect and found that the result was consistently nvarchar(255) across all dialects.
nvarchar(255)