Re: DBD::Oracle and $sth->{PRECISION}

On Thu, Oct 13, 2005 at 01:15:21AM -0400, Eric Lenio wrote:
> Hi,
>
> In perl 5.8.3, DBD::Oracle 1.14, DBI 1.47 I get expected values when I look at
> $sth->{PRECISION} to retrieve the lengths of varchar2 columns for a given
> table.
>
> I'm now testing perl 5.8.7, DBD::Oracle 1.16, and DBI 1.48 and with the same
> table the values in $sth->{PRECISION} for varchar2's are all quadruple what
> they are above. Can anyone shed any light on what might cause this? It seems
> to affect all tables.

Probably due to character set related changes in recent releases.

The best thing to do would be to add some tests to one of the test files
(t/*.t) that demonstrates the problem. Pick a file to change (ie t/20select.t),
copy it (t/20select.t.orig), add the new test, check it fails (make test),
then post the output of "diff -u t/20select.t.orig t/20select.t".

Please also post the two lines of client and server character set
details output by make test.

Tim.
.