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 5:14AM

On Thu, 2002-08-08 at 15:26, 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.


The problem is that client charset is not UTF8 - it's most likely some
version if iso_1. If you set the client charset to UTF8 you should be
fine.

Michael
-- 
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!