Help: Require journal references to software designed to use DBI & similar

2003-09-10 Thread Ron Savage
Hi Folks I've been asked by my university's committee to supply such journal references for a master's proposal. If you have any ideas, please forward privately. TIA. -- Cheers Ron Savage, [EMAIL PROTECTED] on 11/09/2003 http://savage.net.au/index.html

Trying to reach sybperl list, no luck

2003-09-10 Thread Matthew . Persico
Sorry for the intrusion, but can someone familar with sybase please reply? The emails to the sybperl list and owner keep bouncing back. Thanks -- Subject: Compiling Sybperl 2.15 and Sybase 12.5, 64 bit client There is a 50-50 chance that this is my problem, i.e, a busted installation, but I'll t

Re: What to do with UTF-8 data?

2003-09-10 Thread Steve Hay
Tim Bunce wrote: On Wed, Sep 10, 2003 at 11:42:23AM +0100, Steve Hay wrote: Bart Lateur wrote: On Wed, 10 Sep 2003 10:40:29 +0100, Steve Hay wrote: But the question was: How can I arrange for such conversions to be performed automatically by DBI whenever it receives or returns da

Re: What to do with UTF-8 data?

2003-09-10 Thread Steve Hay
Peter J. Holzer wrote: On 2003-09-10 10:40:29 +0100, Steve Hay wrote: But the question was: How can I arrange for such conversions to be performed automatically by DBI whenever it receives or returns data? You could subclass DBI or DBD::MySQL and replace all methods with wrappers which pe

Re: What to do with UTF-8 data?

2003-09-10 Thread Steve Hay
Peter J. Holzer wrote: Since MySQL 4.1 does support UTF-8: Is it possible to upgrade from MySQL 3.23 to 4.1? I might be able to upgrade to 4.0 (I fact, I really ought to...), but I don't fancy 4.1 just yet -- it's still an alpha release :-( - Steve

Re: [PATCH] Three DBD::Oracle Makefile.PL bugs on HP-UX/Oracle 9i

2003-09-10 Thread Tim Bunce
On Wed, Sep 10, 2003 at 12:18:55PM +0200, Jean-Louis Leroy wrote: > I have encountered three problems with the latest (1.14) release of > DBD::Oracle on HP-UX 11 with Oracle 9.2 and perl 5.6.1. Thanks. I'd be grateful if you could rework the patch over my current development version of Makefile.PL

Re: What to do with UTF-8 data?

2003-09-10 Thread Tim Bunce
On Wed, Sep 10, 2003 at 11:42:23AM +0100, Steve Hay wrote: > Bart Lateur wrote: > > >On Wed, 10 Sep 2003 10:40:29 +0100, Steve Hay wrote: > > > >>But the question was: How can I arrange for such conversions to be > >>performed automatically by DBI whenever it receives or returns data? > > > >Well

Re: What to do with UTF-8 data?

2003-09-10 Thread Peter J. Holzer
On 2003-09-10 12:14:25 +0200, Bart Lateur wrote: > On Wed, 10 Sep 2003 10:40:29 +0100, Steve Hay wrote: > > >But the question was: How can I arrange for such conversions to be > >performed automatically by DBI whenever it receives or returns data? > > Well, there are two options... either does t

Re: What to do with UTF-8 data?

2003-09-10 Thread Peter J. Holzer
On 2003-09-10 10:40:29 +0100, Steve Hay wrote: > But the question was: How can I arrange for such conversions to be > performed automatically by DBI whenever it receives or returns data? You could subclass DBI or DBD::MySQL and replace all methods with wrappers which perform the conversion. I'm n

Re: Can't locate object method "TIEHASH" when used in Safe compartment

2003-09-10 Thread Peter
Thanks a lot for your timely response Tim. I think at this point I've given up on using Safe but when I have more time I may try to do it by isolating all the DBI code outside of Safe and see how that goes. Regards, Peter Tim Bunce wrote: I wouldn't hold out much hope of getting DBI and Safe t

Re: What to do with UTF-8 data?

2003-09-10 Thread Steve Hay
Bart Lateur wrote: On Wed, 10 Sep 2003 10:40:29 +0100, Steve Hay wrote: But the question was: How can I arrange for such conversions to be performed automatically by DBI whenever it receives or returns data? Well, there are two options... either does the dtabase somewhere stores the flag

[PATCH] Three DBD::Oracle Makefile.PL bugs on HP-UX/Oracle 9i

2003-09-10 Thread Jean-Louis Leroy
I have encountered three problems with the latest (1.14) release of DBD::Oracle on HP-UX 11 with Oracle 9.2 and perl 5.6.1. $inspdver{rdbms_ver} contains version number 9.200.0.0. Multi-dot version number comparison fails on perl 5.6.1. The "hack up a simple floating point form of the version: 8.1

Re: What to do with UTF-8 data?

2003-09-10 Thread Bart Lateur
On Wed, 10 Sep 2003 10:40:29 +0100, Steve Hay wrote: >But the question was: How can I arrange for such conversions to be >performed automatically by DBI whenever it receives or returns data? Well, there are two options... either does the dtabase somewhere stores the flag indicating that some str

Re: Can't locate object method "TIEHASH" when used in Safe compartment

2003-09-10 Thread Tim Bunce
I wouldn't hold out much hope of getting DBI and Safe to work together like that. Safe is pretty much a failed experiment. Still useful in some cases but generally painful to use and always difficult to prove how much 'safety' you end up with. If you really want to press on then at least upgrade

Re: Problem with proxy server upgrade and storable

2003-09-10 Thread Tim Bunce
Old versions of Storable were more fussy about version mismatch than newer ones. So I think on this occasion you do need to upgrade Storable on clients and servers. Tim. On Tue, Sep 09, 2003 at 05:30:43PM -0700, Douglas Smith wrote: > > Hello All- > > I manage a use of a DBI proxyserver to give

Re: What to do with UTF-8 data?

2003-09-10 Thread Steve Hay
Bart Lateur wrote: On Wed, 10 Sep 2003 08:33:03 +0100, Steve Hay wrote: And when I retrieve the data (again without conversion) I just get octet sequences into my Perl scalars - not flagged, UTF-8 character strings as I would like. If you're *sure* that this is UTF-8, only perl doesn't

Re: What to do with UTF-8 data?

2003-09-10 Thread Bart Lateur
On Wed, 10 Sep 2003 08:33:03 +0100, Steve Hay wrote: >And when I retrieve the data (again >without conversion) I just get octet sequences into my Perl scalars - >not flagged, UTF-8 character strings as I would like. If you're *sure* that this is UTF-8, only perl doesn't flag it as such, you can

Re: What to do with UTF-8 data?

2003-09-10 Thread Peter J. Holzer
On 2003-09-10 08:33:03 +0100, Steve Hay wrote: > Chuck Fox wrote: > >I am a Sybase DBA, but in situations like this, I have declared the > >column on the table to be varbinary or binary and stored the data > >directly without conversion. Don't know if MySql supports this datatype. > > One can

Re: What to do with UTF-8 data?

2003-09-10 Thread Steve Hay
Chuck Fox wrote: Steve, I am a Sybase DBA, but in situations like this, I have declared the column on the table to be varbinary or binary and stored the data directly without conversion. Don't know if MySql supports this datatype. One can declare a column "VARCHAR(n) BINARY" for a similar thi