SqlCe needs to use nchar?

  • Thread starter Thread starter Tim Johnson
  • Start date Start date
T

Tim Johnson

I'm getting conflicting reports about SQL vs. SQLCe - if you're replicating
data from SQL Server down to SQLCe, do the text fields have to be defined in
both places as Unicode (nchar, nvarchar, ntext)? Or only in one, or in
neither? I'd been under the impression ".NetCF/C# and CE is only Unicode"
so I've been coding the schema with nvarchars all over the place. Is that
necessary?

--

Tim Johnson
High Point Software, Inc.
www.high-point.com
(503) 312-8625
 
Read SQL Server CE Books OnLine under index heading "data conversions" for
full coverage
of this topic. In a nutshell, the answer to your question is that ANSI data
within SQL Server is
converted to Unicode for use in SQL CE.

Also - there is a newsgroup "microsoft.public.sqlserver.ce" for your
questions about SQL CE.

Darren Shaffer
Principal Architect
Connected Innovation
 
Back
Top