Re: SQL Server database link problem with varchar

From: gazzag <gareth_at_jamms.org>
Date: Thu, 7 Aug 2008 07:36:44 -0700 (PDT)
Message-ID: <ed02e0d5-5aa1-4dd6-a658-14a63c3d394b@k30g2000hse.googlegroups.com>


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 Received on Thu Aug 07 2008 - 09:36:44 CDT

Original text of this message