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: "Mr dot Dan" <bitsandbytes88 at hotmail dot com>
Subject: bulk copy with sybperl 2.18
Date: May 22 2006 4:41PM


Is there any way to turn on the logged version of bulk copy so that bulk 
copy will work in the 'make test' of sybperl-2.18?  I trying to install 
sybperl-2.18 with OCS_15 querying to ASE 11.9.2.  Or should I just ignore 
that and install it?   I just don't want it to bite me later.  This seems to 
be my last error.

Message String: You cannot run the non-logged version of bulk copy in this 
database. Please check with the DBO.


Setting the LANG variable solved that issue. - THANKS!

>Subject: Re: charactersets with sybperl 2.18
>Date: Mon, 22 May 2006 07:40:27 +0200
>If you unset the LANG and/or LC_ALL environment variables your scripts will
>default to the "C" locale, which itself will default to latin1 (i.e.
>Most of the Sybase client API will handle the charset conversion between
>utf8 and iso1 with no problem, but the Bulk Load API can't do this, and
>that's most likely what fails for you.
> - 19/05/2006 20:43
>Sent by:
>To:    sybperl-l
>Subject:    charactersets with sybperl 2.18
>It turns out that the database character set on the ASE 11.9.2 db I'm
>to connect to uses LATIN1.  Should I use character_set_convert or can I set
>some env to use LATIN1 instead of the default utf8?  I get messages about
>utf8 but it does connect using isql.  The make tes isn't finishing off at
>Thanks again,
> >
> >Hi,
> >
> >I'm getting close to passing all the tests in make tests.  Having the
> >env helped, but I'm still getting this error.
> >
> >Message String: Cannot find the requested character set in Syscharsets:
> >name =
> >'utf8'.
> >
> >I'm not sure what to make of this.  Locales.dat has an entry for utf8.  I
> >wonder if the older characterset used in the database(on 11.9.2 ASE) I'm
> >testing to is using an older or slightly different version had some kind
> >incompatible character set.
> >
> >I also had to revise the interfaces file from this:
> >
> >bean5095d
> >        master tli tcp /dev/tcp \x000213a2438224080000000000000000
> >        query tli tcp /dev/tcp \x000213a2438224080000000000000000
> >
> >bean5095d
> >        master tcp ether prune 5095
> >        query tcp ether prune 5095
> >
> >
> >I'm using OCS-15_0 with sybperl-2.18.
> >
> >Thanks,
> >~DjK
> >
> >
>This message and any attachments (the "message") is
>intended solely for the addressees and is confidential.
>If you receive this message in error, please delete it and
>immediately notify the sender. Any use not in accord with
>its purpose, any dissemination or disclosure, either whole
>or partial, is prohibited except formal approval. The internet
>can not guarantee the integrity of this message.
>BNP PARIBAS (and its subsidiaries) shall (will) not
>therefore be liable for the message if modified.
>                 ---------------------------------------------
>Ce message et toutes les pieces jointes (ci-apres le
>"message") sont etablis a l'intention exclusive de ses
>destinataires et sont confidentiels. Si vous recevez ce
>message par erreur, merci de le detruire et d'en avertir
>immediatement l'expediteur. Toute utilisation de ce
>message non conforme a sa destination, toute diffusion
>ou toute publication, totale ou partielle, est interdite, sauf
>autorisation expresse. L'internet ne permettant pas
>d'assurer l'integrite de ce message, BNP PARIBAS (et ses
>filiales) decline(nt) toute responsabilite au titre de ce
>message, dans l'hypothese ou il aurait ete modifie.