Re: SQL Server database link problem with varchar

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)?
>
> -g

VARCHAR(4000)
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