Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Burstin <mikeb at concerto dot com>
Subject: Re: Sybase::BLK and unicode
Date: Aug 9 2002 12:45PM

A system() call will result in the same issue -- I just was dealing
with the same issue from command line BCP, and needed to add a command
line arg (maybe "-J utf8", something to specify the client charset).
I am guessing that there is the equivalent for sybperl in the
connect call...

On Thu, Aug 08, 2002 at 03:48:20PM -0700, Dennis Domingo wrote:
> Steve:
> Is your Sybase server 12.5.x?  In my experience Sybase::BLK appears to have problems with with Sybase 12.5.x when the data in the data is stored in UTF8.
> My solution is to use system() call and use the bcp utilities directly.
> dd
> wrote:Hi folks-
> I'm using Sybase::BLK routines to transfer data from an iso server
> to a unicode server using perl5.6.
> Should this be possible to do?
> This is the message I currently receive:
> Message number: 4847, Severity 16, State 1, Line 1
> Server 'NYTUNV3T002'
> Message String: BCP insert operation is disabled when LONGCHAR capability is turned on and data size is changing between client and server character sets since BCP does not support LONGCHAR yet.
> I'm open to experiment and turn of LONGCHAR but not sure how to do that. Any
> pointers welcome.
> Thanks,
> Steve
> ---------------------------------
> Do You Yahoo!?
> HotJobs, a Yahoo! service - Search Thousands of New Jobs
Michael Burstin
NPI Engineer
Concerto Software