PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Stephen dot Sprague at morganstanley dot com
Subject: Re: Sybase::BLK and unicode (fwd)
Date: Aug 8 2002 11:08PM

dennis-
yes. I should have given out more version information.
   my target server is a 12.5.x  (unicode)
   my source server is a 11.9.x  (iso)
   my ctlib is 12.0
   my perl is 5.6

I'm holding out for a workaround. Up  until  now  Sybase::BLK  has  been
performing as advertised.


Cheers,
Steve



---------- Forwarded message ----------
Date: Thu, 8 Aug 2002 15:48:20 -0700 (PDT)
From: Dennis Domingo 
Reply-To: SYBPERL-L@list.cren.net
To: SybPerl Discussion List 
Subject: Re: Sybase::BLK and unicode


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

 Stephen.Sprague@morganstanley.com 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