ntext vs. nchar

pedro.godinho

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!

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

pedro.godinho21y ago
Sure. I'll try to be more specific. I have something like this: DataTable my_table = my_connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns,new object[] {null,null,table,null}); foreach(DataRow row in my_table.Rows) { int type = (int)row["DATA_TYPE"]; Console.WriteLine(type); } What's being written to the Console is "130" for both ntext and nchar. I would like to be able to distinguish between ntext and nchar, but the DATA_TYPE is the same for both.
0
miker21y ago
I don't get it. Could you explain a little more what are you trying to do?
0