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: 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
>  
>  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
-- 
Michael Burstin
NPI Engineer
Concerto Software
978-952-0842
mikeb@concerto.com