ntext vs. nchar

Mar 15 2005 6:53 AM
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!

Answers (2)