Identifying nvarchar type

[RichardDunneBSc]

Visual Studio Community 2019. I am trying to execute a select query with 5 columns in a where clause. 4 or the five columns are of type varchar, 1 of type text. There are no columns of type nvarchar. Yet, I am getting an exception on the execution: "The data types text and nvarchar are incompatible in the equal to operator". I am using Parameters.AddWithValue("@Column",objectValue), all data types are matching.

Is there a way through debugging to find out which column it is identifying as type nvarchar?

Continue reading...