Re: DBD::mysql 4.046 released

2018-02-09 Thread H.Merijn Brand
might have > Many thanks to the Pali Rohár, Ville Skyttä, Michiel Beijen, and of > course the community! -- H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/ using perl5.00307 .. 5.27 porting perl5 on HP-UX, AIX, and openSUSE http://mirrors.develooper.com/hpux/ht

Re: Oracle encoding query

2017-12-06 Thread H.Merijn Brand
On Wed, 6 Dec 2017 15:34:17 +, Tim Bunce wrote: > On Wed, Dec 06, 2017 at 04:12:53PM +0100, H.Merijn Brand wrote: > > On Wed, 6 Dec 2017 15:50:11 +0100, "H.Merijn Brand" > > > > > > I have been playing with several variants of > > > >

Re: Oracle encoding query

2017-12-06 Thread H.Merijn Brand
On Wed, 6 Dec 2017 15:50:11 +0100, "H.Merijn Brand" wrote: > I have an Oracle databse with NLS_CHARACTERSET US7ASCII > > I have a table "land", like > > create table land ( > c_land number (4) not null, > zoek

Oracle encoding query

2017-12-06 Thread H.Merijn Brand
riants of select convert (land_u, 'AL16UTF16', 'UTF8') from land where c_land = 7072; but I didn't get SQL Developer to show the ë -- H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/ using perl5.00307 .. 5.27 porting perl5 on HP-UX, AIX, and openSUS

Re: DBD::mysql path forward

2017-11-09 Thread H.Merijn Brand
old code. Backward compatibility is important. More than you think. How angry would you be if we broke DBI? -- H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/ using perl5.00307 .. 5.27 porting perl5 on HP-UX, AIX, and openSUSE http://mirrors.develooper.com/hpux/http:

Re: DBD::mysql path forward

2017-09-14 Thread H.Merijn Brand
( So, *if* you test with combining characters (that do not represent in a single codepoint) make sure it matches the Unicode defined order FYI This is why I still don't support *real* binary in perl6' Text::CSV -- H.Merijn Brand http://tux.nl Perl Monger http://amsterdam

Re: DBD::mysql path forward

2017-09-13 Thread H.Merijn Brand
. 1. create two tables with a field of the type to check 2. insert the data in table 1 3. use SQL to copy the data to table 2 4. extract data from table 2 5. compare to original data 6. drop tables 7. goto 1 If MySQL support different ways to do this, test all ways (in the string, placeholde

Re: Fork DBD::mysql

2017-09-01 Thread H.Merijn Brand
his year. NOT dead. Please try to contact Michiel first. Author: Michiel Beijen 2017-06-29 11:25:48 Committer: Michiel Beijen 2017-06-29 11:30:07 Tags: 4.043 Parent: 1ece6b4b8630a1cf348373aa41cbe5f748dcd62a (Merge pull request #137 from pali/versions) Branch: remotes/origin/master Follows: 4.042

Re: Please test DBI-1.628_50 re change in PrintWarn

2013-10-11 Thread H.Merijn Brand
: dbdimp.c:2781:17: warning: cast to pointer from integer of different size [-Wint-to-pointer-cast] dbdimp.c: In function ‘ora_st_execute_array’: dbdimp.c:3720:8: error: void value not ignored as it ought to be dbdimp.c: At top level: dbdimp.c:34:1: warning: ‘dbi_get_state’ defined but not

Re: Announce DBI 1.628 => Announce DBD::CSV 0.39

2013-07-22 Thread H.Merijn Brand
a DBI::DBD::SqlEngine > engines (DBD::CSV, DBD::DBM etc.) [H.Merijn Brand, Jens Rehsack] > Fixed stack corruption on callbacks RT#85562 RT#84974 [Aaron Schweiger] > Fixed DBI::SQL::Nano_::Statement handling of "0" [Jens Rehsack] > Fixed exit op precedence i

Re: DBD::CSV and skip_first_line

2012-11-26 Thread H.Merijn Brand
On Mon, 26 Nov 2012 12:29:25 -0500, "Scott R. Godin" wrote: > On 11/26/2012 11:56 AM, H.Merijn Brand wrote: > > On Mon, 26 Nov 2012 11:49:49 -0500, "Scott R. Godin" > > wrote: > > > > On 11/25/2012 04:16 AM, Jens Rehsack wrote: > >>>

Re: DBD::CSV and skip_first_line

2012-11-26 Thread H.Merijn Brand
On Mon, 26 Nov 2012 11:49:49 -0500, "Scott R. Godin" wrote: > > On 11/25/2012 04:16 AM, Jens Rehsack wrote: > > On 25.11.12 10:00, H.Merijn Brand wrote: > >> On Fri, 23 Nov 2012 17:43:50 -0500, "Scott R. Godin" > >> wrote: > >> >

Re: DBD::CSV and skip_first_line

2012-11-25 Thread H.Merijn Brand
in original dump > > what do ? :) Rewrite the headers with Text::CSV_XS before using DBD::CSV -- H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/ using perl5.00307 .. 5.17 porting perl5 on HP-UX, AIX, and openSUSE http://mirrors.develooper.com/hpux/http://www.test-smoke.org/ http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/

Re: Do you use PostgreSQL PL/Perl?

2010-12-06 Thread H.Merijn Brand
p to me if I could get a better idea of how other > people use PostgreSQL PL/Perl. > > What kinds of things do you use PL/Perl in the server for? Not, none (yet). > How much PL/Perl code do you have (approximate number of functions and lines)? > What kinds of CPAN modules would you lik

DBD::CSV 0.29 has been released

2010-05-04 Thread H.Merijn Brand
Error => 1, FetchHashKeyName => "NAME_lc", }) or die $DBI::errstr; 2010-05-03 0.29 H.Merijn Brand * Fix git URL in META.yml * Add empty CLONE method to prevent warning when cloning threads * Minimum perl 5.8.1

ANNOUNCE: DBD::CSV 0.25

2009-10-15 Thread H.Merijn Brand
0.25 version will move along with that and with new releases of S::S, new releases of DBD::CSV will be required. Enjoy! file: $CPAN/authors/id/H/HM/HMBRAND/DBD-CSV-0.25.tgz size: 25557 bytes md5: 741362f1427768b664d98fff4b12bc9c 2009-10-15 H.Merijn Brand (0.25) * Raised mi

ANNOUNCE: DBD-Unify 0.77

2009-06-19 Thread H.Merijn Brand
.3I on HP-UX 11.23 with perl 5.10.0 - Tested with Unify 8.3K on AIX 5.2.0.0 with perl 5.8.8 Tests will fail on older perls, as the test cases use scalarIO -- H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/ using & porting perl 5.6.2, 5.8.x, 5.10.x, 5.11.x on HP-

Re: DBD & SQL::Statement change in Maintainership

2009-04-19 Thread H.Merijn Brand
ning SQL::Statement and various pure-Perl DBDs > > > (RAM, AnyData, File, CSV) I've now finally admitted that I am far too > > > busy > > > to do an adequate job with the modules. Although I'll stay on as > > > co-maintainer and help out when I can

Re: DBD::Oracle + BLOB

2008-10-30 Thread H.Merijn Brand
g to do, but be sure to read the ODBC manual > > > > to ensure you can implement the exact semantics. Otherwise you're just > > > > creating a new portability problem. > > > > > > > > Generally, driver authors should aim to do what ODBC (and ideally

Re: DBD::Oracle + BLOB

2008-10-30 Thread H.Merijn Brand
ypes. > > > >> The tack I am looking at is some sort of flag where you tell you > >> DBD to explicitly describe before an execute. > >> > >> Not sure if that could even be done with a update though at least with > >> Oracle > >> > >&g

Re: DBD::Oracle + BLOB

2008-10-30 Thread H.Merijn Brand
On Thu, 30 Oct 2008 15:25:05 +0100, Mark Lawrence <[EMAIL PROTECTED]> wrote: > On Thu Oct 30, 2008 at 02:34:55PM +0100, H.Merijn Brand wrote: > > On Thu, 30 Oct 2008 09:06:52 -0400, John Scoles <[EMAIL PROTECTED]> > > wrote: > > > > > Ok looks like you n

Re: DBD::Oracle + BLOB

2008-10-30 Thread H.Merijn Brand
$stu->update ($aant, $c_aant); } else { $sti->insert ($c_aant, $aant); } } $dbh->commit; } -->8--- notes 1. prepar () is just a wrapper around $dbh->prepare () 2. ->update () and ->insert () are wrappers a

DBD::Oracle + BLOB

2008-10-30 Thread H.Merijn Brand
update w_test setw_test = ? where c_test = ? and v_test = 1" with ParamValues: :p1='foo bar', :p2=1] at w-test.pl line 39. $ perl -MV=DBD::Oracle DBD::Oracle /pro/asql/o82C/lib/perl/5.8.8/DBD/Oracle.pm: 1.22 Same for Oracle 8, Oracle 9 and Oracle 10 --

ANNOUNCE: DBD-Unify 0.75

2008-09-23 Thread H.Merijn Brand
uni-basic we need more tests for %ENV variable setting like $LC_ALL, $DATEFMT etc Enjoy, Have FUN! -- H.Merijn Brand Amsterdam Perl Mongers http://amsterdam.pm.org/ using & porting perl 5.6.2, 5.8.x, 5.10.x, 5.11.x on HP-UX 10.20, 11.00, 11.11, 11.23, and 11.31, SuSE

Announce: DBD-Unify-0.65

2007-08-20 Thread H.Merijn Brand
DBD-Unify-0.65.tgz has entered CPAN as file: $CPAN/authors/id/H/HM/HMBRAND/DBD-Unify-0.65.tgz size: 37975 bytes md5: 69481ea2e70ec27d67349218dfb0bc82 No action is required on your part Request entered by: HMBRAND (H.Merijn Brand) Request entered on: Mon, 20 Aug 2007 16:36:06 GMT Request

Re: ANNOUNCE: DBI 1.57

2007-06-19 Thread H.Merijn Brand
! > > Tim. > > p.s. I've a new module, called DashProfiler, that provides a simple, > flexible, efficient way to add performance monitoring to an application, > especially web applications. It's trivial to track the time spent inside > specific blocks of code, or the

[ANNOUNCE] Text-CSV_XS 0.27

2007-05-31 Thread H.Merijn Brand
2007-05-31 0.27 - H.Merijn Brand <[EMAIL PROTECTED]> * checked with perlcritic (still works under 5.00504) so 3-arg open cannot be used (except in the docs) * 3-arg open in docs too * Added a lot to the TODO list * Some more info on using

Re: RFC: The future of Text::CSV_XS

2007-05-25 Thread H.Merijn Brand
: -S Only print sheets . 'all' is a valid set Default only prints the first sheet -ROnly print rows. Default is 'all' -COnly print columns . Default is 'all' -FOnly fields e.g. -FA3,B16 /home/merijn 102

RFC: The future of Text::CSV_XS

2007-05-25 Thread H.Merijn Brand
tion on the call: my @AoH = $csv->parse_file ($filename, { cols => [ 1, 4..8, 12 ]}); Returning something like [ { fields => [ 1, 2, "foo", 4.5, undef, "", 8 ], flags => [ ... ], errors => [ ... ], }, { fields => [ ... ],

Re: Proposal for new $h->{ReadOnly} attribute

2007-05-01 Thread H.Merijn Brand
er considers the C attribute when > making a decison about whether to retry an operation that failed. > > =cut Is it inherited? Do statement handles from a ReadOnly driver handle get the same attribute passed? If so: useful. I'd like to see that extended to be able to allow dirty read

ANNOUNCE: DBD-Unify-0.60

2006-02-10 Thread H.Merijn Brand
contact me if that i your environment. -- H.Merijn BrandAmsterdam Perl Mongers (http://amsterdam.pm.org/) using & porting perl 5.6.2, 5.8.x, 5.9.x on HP-UX 10.20, 11.00, 11.11, & 11.23, SuSE 10.0, AIX 4.3 & 5.2, and Cygwin. http://qa.perl.org https://beepz.com/personal/merijn/ perlsmoke: http://www.test-smoke.org

Re: Sourceforge Project Name?

2004-09-20 Thread H.Merijn Brand
On Thu 16 Sep 2004 22:36, Jeff Zucker <[EMAIL PROTECTED]> wrote: > SQL::Statement As a side note, could you rewrite the test cases on this one to fit in the general format of testing output, instead of the list of 100 numbers? Suggest using Test::Simple or Test::More -- H.Mer

Re: ANNOUNCE: DBI 1.42

2004-03-16 Thread H.Merijn Brand
and use (except that using the > ScanLevel attribute in DBD::Unify may cause problems). > > Enjoy! -- H.Merijn BrandAmsterdam Perl Mongers (http://amsterdam.pm.org/) using perl-5.6.1, 5.8.0 & 633 on HP-UX 10.20 & 11.00, AIX 4.2, AIX 4.3, WinNT 4, Win2K pro & WinCE

ANNOUNCE: DBD-Unify 0.30

2004-03-02 Thread H.Merijn Brand
updates to ChangeLog and README Share and Enjoy, Have FUN! -- H.Merijn BrandAmsterdam Perl Mongers (http://amsterdam.pm.org/) using perl-5.6.1, 5.8.0, & 5.9.x, and 806 on HP-UX 10.20 & 11.00, 11i, AIX 4.3, SuSE 8.2, and Win2k. http://www.cmve.net/~merijn/ http:

Re: (Fwd) CPAN Upload: T/TI/TIMB/DBD-Oracle-1.14.tar.gz

2003-04-03 Thread H.Merijn Brand
I 7 and Oraperl will not be supported in future releases. > > Implemented inserting NULL values into LOB fields using placeholders, > (sponsored by bayerwald-fenster.de thanks to Bernhard Donaubauer). > Fixed broken get_info() due to missing GetInfo.pm #2274. > Fixed compile

Re: (Fwd) CPAN Upload: T/TI/TIMB/DBD-Oracle-1.14.tar.gz

2003-03-28 Thread H.Merijn Brand
supported in future releases. > > Implemented inserting NULL values into LOB fields using placeholders, > (sponsored by bayerwald-fenster.de thanks to Bernhard Donaubauer). > Fixed broken get_info() due to missing GetInfo.pm #2274. > Fixed compiler warnings/errors thanks to H

Re: Perl 5.8.0 Problem

2002-08-29 Thread H.Merijn Brand
t "\n"; > > $dbh->commit; > $dbh->disconnect; > > use DBI; > -- End of code --- > > Please note that $name is assigned to be a string of space. It works fine on > PERL 5.6.1, but when I ran

Re: ANNOUNCE: DBI 1.30

2002-07-19 Thread H.Merijn Brand
EN arg (arg 5) DBI.xs: In function `dbih_make_com': DBI.xs:758: warning: int format, STRLEN arg (arg 5) DBI.xs: In function `XS_DBD_st_bind_col': DBI.xs:3347: warning: operation on `lna' may be undefined DBI.xs: In function `XS_DBD_st_bind_columns': DBI.xs:3368: warnin

ANNOUNCE: DBD-Unify-0.24

2002-05-28 Thread H.Merijn Brand
te. Notably t/21-uni-regex.t to see if the SHLIKE bug exists in the current configuration - Minor adjustments for DBI-1.19 and table_info change - Added link_info (experimental) -- H.Merijn BrandAmsterdam Perl Mongers (http://amsterdam.pm.org/) using perl-5.6.1, 5.7.3