According to http://www.w3schools.com/ado/ado_datatypes.asp, ntext has a value of 203. In .net, however, the return value is 130, the same as for nchar. This is a problem, because I'm creating a query, and an Exception is being thrown if I compare two ntexts using equal. The same exception is not thrown for nchars, but since I can't figure out which ones are ntexts and which ones are nchars, I can't create a clean query which doesn't contain ntexts.
Does anyone know how I can figure out which fields are ntexts and which ones are nchars?
Thanks!