main logo
Subject: Re: String or binary data would be truncated
Author: "Ted Roche"
Posted: 2006/06/30 15:10:33
 
View Entire Thread
New Search


On 6/30/06, Jim Winter <jimw (AT) proadv D.O.T com> wrote:
> Getting the message 'String or binary data would be truncated.' when I try
> to save an updated remote view back to SQL Server
> <http://www.microsoft.com/sql> .
>

You don't mention your version of FoxPro. Earlier versions had trouble
with Unicode fields where lengths were returned in bytes, which are
twice the number of characters allowed in the fields. Take a look at
the SQL Server structure definitions and see if this might be the
cause.

--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com



 
©2006 Ted Roche
<-- Prior Message New Search Next Message -->