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 Peppler <mpeppler at peppler dot org>
Subject: Re: Sybase::BLK and unicode
Date: Aug 9 2002 1:24PM

On Fri, 2002-08-09 at 05:45, Michael Burstin wrote:
> 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...

Indeed - see the Sybase::CTlib man page - the Sybase::BLK new() call has
the same format.

It goes something like this:

$dbh = new Sybase::BLK $user, $pwd, $server, $appname, 
                  { CON_PROPS => { CS_SYB_CHARSET => 'utf8' }};

Michael


> 
> 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
> 
> 
-- 
Michael Peppler / mpeppler@peppler.org / http://www.mbay.net/~mpeppler
mpeppler@zetatools.com / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!