Best datatype for a "notes" column?
- From: "Earl" <brikshoe@xxxxxxxxxxxxxxxxx>
- Date: Wed, 14 Jun 2006 03:18:01 -0400
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."
.
- Prev by Date: Re: SQL 2005 - Full Text Index and Merge Replication
- Next by Date: Run script in the event of failover
- Previous by thread: Re: How do you replicate replicate a full text index on 2000
- Next by thread: Run script in the event of failover
- Index(es):
Relevant Pages
|
