Re: sqlce: nvarchar(80) vs. ntext

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: mgarner1980 (mgarner_at_kbsi.com)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 18:08:42 -0500

I ran across this and somewhere (books online???) I found that I had to use
a " like" instead of = for ntext types. it worked for me.
"Sujoy Gupta" <sujoyg@removethis.cc.gatech.edu> wrote in message
news:uymhCGkVEHA.4092@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I am assuming the exception is because of the fact that you are trying to
> use ntext field in the 'WHERE' clause. Binary types and ntext are *not*
> supported in the where clause.
>
> Sujoy
>
> "microsoft" <curtis@synergyontheweb.com> wrote in message
> news:%23jCVZKQREHA.3504@TK2MSFTNGP09.phx.gbl...
> > When we create a database using nvarchar(80) ...or some number... as the
> > datatype we can then use a "Select" statement to retrieve data. When we
> use
> > ntext as the datatype the database is created successfully (from a text
> > file) but we get an unhandled exception when trying to use a select
> > statement. Any clues?
> >
> >
>
>