On Wed, Oct 20, 2004 at 03:49:25PM +0100, Tim Bunce wrote:
> Yes, another release candidate!
>
> I think I've finally got to the bottom of the character set issues.
[...]
> I'd be especially grateful for reports of testing of ...
> - a range of Oracle versions, especially 8.1.x and even 8.0.x
Hello Tim,
This is perl, v5.8.3 built for i386-linux-thread-multi
and
Database and client versions and character sets:
Database 8.0.5.2.1 CHAR set is EE8ISO8859P2 (Non-Unicode), NCHAR set is EE8ISO8859P2
(Non-Unicode)
Client 9.2.0.0.0 NLS_LANG is '<unset>', NLS_NCHAR is '<unset>'
and I get
t/23wide_db_8bit........set $ENV{NLS_LANG}=AMERICAN_AMERICA.WE8MSWIN1252
dubious
Test returned status 0 (wstat 11, 0xb)
Scalar found where operator expected at (eval 154) line 1, near "'int' $__val"
(Missing operator before $__val?)
[...]
t/25plsql...............1..83
[...]
ok 65
After p1=[Hello] p2=[Y] p3=[Y]
test nvarchar2 arg passing to functions
Can't call method "bind_columns" on an undefined value at t/25plsql.t line 319.
# failed test 66 at line 318
not ok 66
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 66-83
Failed 18/83 tests, 78.31% okay
[...]
Failed 2/18 test scripts, 88.89% okay. 18/1720 subtests failed, 98.95% okay.
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/23wide_db_8bit.t 0 11 ?? ?? % ??
t/25plsql.t 2 512 83 35 42.17% 66-83
6 tests and 131 subtests skipped.
All other tests are either skipped (it is not a Unicode database)
or passed.
For the same perl and
Database and client versions and character sets:
Database 10.1.0.2.0 CHAR set is AL32UTF8 (Unicode), NCHAR set is UTF8 (Unicode)
Client 9.2.0.0.0 NLS_LANG is '<unset>', NLS_NCHAR is '<unset>'
t/21nchar............... Database and client versions and character sets:
Database 10.1.0.2.0 CHAR set is AL32UTF8 (Unicode), NCHAR set is UTF8 (Unicode)
Client 9.2.0.0.0 NLS_LANG is '<unset>', NLS_NCHAR is '<unset>'
set $ENV{NLS_NCHAR}=WE8ISO8859P1
dubious
Test returned status 0 (wstat 11, 0xb)
Scalar found where operator expected at (eval 154) line 1, near "'int' $__val"
(Missing operator before $__val?)
[...]
t/23wide_db_8bit........set $ENV{NLS_LANG}=AMERICAN_AMERICA.WE8MSWIN1252
dubious
Test returned status 0 (wstat 11, 0xb)
[...]
Failed 2/18 test scripts, 88.89% okay. 0/1905 subtests failed, 100.00% okay.
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/21nchar.t 0 11 ?? ?? % ??
t/23wide_db_8bit.t 0 11 ?? ?? % ??
1 test and 122 subtests skipped.
For a combination of
Database and client versions and character sets:
Database 10.1.0.2.0 CHAR set is AL32UTF8 (Unicode), NCHAR set is UTF8 (Unicode)
Client 10.1.0.2 NLS_LANG is '<unset>', NLS_NCHAR is '<unset>'
all is fine and nice, all tests pass (or are skipped).
Anything I can check (or add more info) concerning the failures on
the 9.2 client?
--
------------------------------------------------------------------------
Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/
.project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ...
Only self-confident people can be simple.