Recommendation for a datatype for replication
- From: "Earl" <brikshoe@xxxxxxxxxxxxxxxxx>
- Date: Wed, 14 Jun 2006 14:32:26 -0400
Posted this over in the sqlserver replication forum without any response, so
hopefully someone here can advise:
I need a recommendation for a column datatype where I need to save what
might commonly just be called a "note". The note may be very short, it may
be very long. I have been using nvarchar 2000, but due to some issues I'm
having with synchronization, I'm concerned about the data mapping from SQL
to SQLCE. In the SQLCE 2.0 BOL (replication > data types), it states:
"national character varying
If the length of the data is 255 characters or less; SQL Server CE
replication maps the SQL Server national character varying data to SQL
Server CE national character varying; otherwise, it maps it to SQL Server CE
ntext.
If the length of the ntext data exceeds the length of the national character
varying column, synchronization fails when the data is sent from the SQL
Server CE subscription to the SQL Server publication."
.
- Follow-Ups:
- Re: Recommendation for a datatype for replication
- From: Darren Shaffer
- Re: Recommendation for a datatype for replication
- Prev by Date: Re: error 80004005 while INITIALIZE sql server CE
- Next by Date: Re: Recommendation for a datatype for replication
- Previous by thread: Novice Question SQL 2005 Mobile
- Next by thread: Re: Recommendation for a datatype for replication
- Index(es):
Relevant Pages
|
