Re: SQL Server database link problem with varchar
Date: Thu, 7 Aug 2008 12:11:04 -0700 (PDT)
On 7 ago, 11:36, gazzag <gar..._at_jamms.org> wrote:
> On 7 Aug, 14:53, Oberdan Nunes <oberdannu..._at_gmail.com> wrote:
> > Hi, someone could help me?
> > I have a database link to a SQL Server 2005 that is used to insert
> > data from
> > Oracle to SQL Server Database.
> > When I try to insert VARCHAR columns with more than 255 characters,
> > the data
> > is truncate in exactly 255 characters :(
> > What I'm doing wrong?
> > Tks
> > Oberdan
> What is the table definition on the target database? Is the field in
> question VARCHAR(255)?
We made some tests on a version 10g and it worked fine, but non in the 9i. Received on Thu Aug 07 2008 - 14:11:04 CDT