On Thu, Jan 29, 2004 at 12:46:49PM +0100, Honza Pazdziora wrote: > On Wed, Jan 28, 2004 at 04:09:16PM +0000, Tim Bunce wrote: > > After 10 months of, er, stability, I'm very happy to release a new > > version of DBD::Oracle. This one should build more happily on more > > systems with more recent versions of Oracle. > > The following patch is needed to make DBD::Oracle 1.15 run > with NLS_LANG=AMERICAN_AMERICA.UTF8 on database with character set > EE8ISO8859P2. It's inspired by Frank Adler's post > > http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=utf-8&inlang=pl&selm=f3eafca5.0201300213.19e3914f%40posting.google.com > > any by observing that other pieces of oci8.c multiply by 10, instead > of Frank's value of 2: > > --- oci8.c.orig 2004-01-10 01:00:34.000000000 +0100 > +++ oci8.c 2004-01-29 12:24:11.000000000 +0100 > @@ -1067,7 +1067,7 @@ > avg_width = fbh->dbsize / 2; > /* FALLTHRU */ > case 96: /* CHAR */ > - fbh->disize = fbh->dbsize; > + fbh->disize = fbh->dbsize * 10; > fbh->prec = fbh->disize; > break; > case 23: /* RAW */ > > Without this patch, some of my selects fail with > > ORA-24345: A Truncation or null fetch error occurred (DBD ERROR: ORA-01406 error on > field 1 of 24, ora_type 1)
Thanks. Tim.
