bulk copy with sybperl 2.18
"Mr. Dan" <[email protected]> Mon, 22 May 2006 12:41:33 -0400
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase |
|---|---|
| Message-ID | <[email protected]> |
Hi, 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. ~DjK Setting the LANG variable solved that issue. - THANKS! >From: [email protected] >To: [email protected] >CC: [email protected] >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. >iso8859). > >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. > >Michael > > > > > >Internet >[email protected]@peppler.org - 19/05/2006 20:43 > > >Sent by: [email protected] > >To: sybperl-l > >cc: > > >Subject: charactersets with sybperl 2.18 > > > >Hi, > >It turns out that the database character set on the ASE 11.9.2 db I'm >trying >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 >100%. > >Thanks again, >~DjK > > > > > > > > >Hi, > > > >I'm getting close to passing all the tests in make tests. Having the >right > >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 >on > >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. >