Hi John. Here's the info: Red Hat Enterprise Linux AS release 3 (Taroon Update 5)
uname -a: Linux ********** 2.4.21-32.ELsmp #1 SMP Fri Apr 15 21:17:59 EDT 2005 i686 i686 i386 GNU/Linux Thanks, Andrew -----Original Message----- From: John Scoles [mailto:[EMAIL PROTECTED] Sent: Thursday, May 11, 2006 7:30 AM To: Chen, Andrew; dbi-users@perl.org Subject: Re: Test t/24implicit_utf8.t fails when compiling DBD-Oracle-1.17 Seems that UTF8 is raising its ugly head again. I will take a note of it an look into today if I get some time. I just need to confirm what sort of platform you are using OS =? Oracle version = 9.2.0.4.0 Oracle Client = 9.2.0.4 DBI =1.5 DBD:Oracle = 1.17 Cheers. John Scoles ----- Original Message ----- From: "Chen, Andrew" <[EMAIL PROTECTED]> To: <dbi-users@perl.org> Sent: Wednesday, May 10, 2006 5:09 PM Subject: Test t/24implicit_utf8.t fails when compiling DBD-Oracle-1.17 The following test is failing during make test: [EMAIL PROTECTED] DBD-Oracle-1.17]# perl -Mblib t/24implicit_utf8.t --- testing implicit csform (dbhimp.c sets csform implicitly) 1..74 row: 1: nice_string=\x03 byte_string=3 (, '.') row: 2: nice_string=a byte_string=97 (a, 'a') row: 3: nice_string=b byte_string=98 (b, 'b') row: 4: nice_string=\x{263A} byte_string=226|152|186 (âº, "âº") --- testing with NLS_NCHAR=UTF8 set $ENV{NLS_NCHAR}=UTF8 Database 9.2.0.4.0 CHAR set is WE8ISO8859P1 (Non-Unicode), NCHAR set is AL16UTF16 (Unicode) Client 9.2.0.4 NLS_LANG is 'AMERICAN_AMERICA.WE8ISO8859P1', NLS_NCHAR is 'UTF8' create table dbd_ora__drop_me ( idx integer, nch nvarchar2(20), descr varchar2(50), dt date ) ok 1 - prepared: insert into dbd_ora__drop_me ( idx, nch, descr, dt ) values( ?, ?, ?, sysdate ) ok 2 - bind_param idx ok 3 - bind_param nch ok 4 - bind_param descr withOUT attribute ora_csform ok 5 - insert row 1: control-C ok 6 - bind_param idx ok 7 - bind_param nch ok 8 - bind_param descr withOUT attribute ora_csform ok 9 - insert row 2: lowercase a ok 10 - bind_param idx ok 11 - bind_param nch ok 12 - bind_param descr withOUT attribute ora_csform ok 13 - insert row 3: lowercase b ok 14 - bind_param idx ok 15 - bind_param nch ok 16 - bind_param descr withOUT attribute ora_csform ok 17 - insert row 4: smiley face ok 18 - prepared: select nch, descr, DUMP(nch), dt from dbd_ora__drop_me order by idx ok 19 - bind column nch ok 20 - bind column descr ok 21 - byte_string test of row 1: column: nch (uft8) control-C ok 22 - nice_string test of row 1: column: nch (uft8) control-C ok 23 - byte_string test of row 1: column: descr control-C ok 24 - nice_string test of row 1: column: descr control-C ok 25 - byte_string test of row 2: column: nch (uft8) lowercase a ok 26 - nice_string test of row 2: column: nch (uft8) lowercase a ok 27 - byte_string test of row 2: column: descr lowercase a ok 28 - nice_string test of row 2: column: descr lowercase a ok 29 - byte_string test of row 3: column: nch (uft8) lowercase b ok 30 - nice_string test of row 3: column: nch (uft8) lowercase b ok 31 - byte_string test of row 3: column: descr lowercase b ok 32 - nice_string test of row 3: column: descr lowercase b not ok 33 - byte_string test of row 4: column: nch (uft8) smiley face # Failed test 'byte_string test of row 4: column: nch (uft8) smiley face' # in t/nchar_test_lib.pl at line 341. # got: '38|58' # expected: '226|152|186' not ok 34 - nice_string test of row 4: column: nch (uft8) smiley face # Failed test 'nice_string test of row 4: column: nch (uft8) smiley face' # in t/nchar_test_lib.pl at line 344. # got: '&:' # expected: '\x{263A}' ok 35 - byte_string test of row 4: column: descr smiley face ok 36 - nice_string test of row 4: column: descr smiley face # row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58 ok 37 - number of rows fetched --- testing with NLS_NCHAR=AL32UTF8 set $ENV{NLS_NCHAR}=AL32UTF8 Database 9.2.0.4.0 CHAR set is WE8ISO8859P1 (Non-Unicode), NCHAR set is AL16UTF16 (Unicode) Client 9.2.0.4 NLS_LANG is 'AMERICAN_AMERICA.WE8ISO8859P1', NLS_NCHAR is 'AL32UTF8' create table dbd_ora__drop_me ( idx integer, nch nvarchar2(20), descr varchar2(50), dt date ) ok 38 - prepared: insert into dbd_ora__drop_me ( idx, nch, descr, dt ) values( ?, ?, ?, sysdate ) ok 39 - bind_param idx ok 40 - bind_param nch ok 41 - bind_param descr withOUT attribute ora_csform ok 42 - insert row 1: control-C ok 43 - bind_param idx ok 44 - bind_param nch ok 45 - bind_param descr withOUT attribute ora_csform ok 46 - insert row 2: lowercase a ok 47 - bind_param idx ok 48 - bind_param nch ok 49 - bind_param descr withOUT attribute ora_csform ok 50 - insert row 3: lowercase b ok 51 - bind_param idx ok 52 - bind_param nch ok 53 - bind_param descr withOUT attribute ora_csform ok 54 - insert row 4: smiley face ok 55 - prepared: select nch, descr, DUMP(nch), dt from dbd_ora__drop_me order by idx ok 56 - bind column nch ok 57 - bind column descr ok 58 - byte_string test of row 1: column: nch (uft8) control-C ok 59 - nice_string test of row 1: column: nch (uft8) control-C ok 60 - byte_string test of row 1: column: descr control-C ok 61 - nice_string test of row 1: column: descr control-C ok 62 - byte_string test of row 2: column: nch (uft8) lowercase a ok 63 - nice_string test of row 2: column: nch (uft8) lowercase a ok 64 - byte_string test of row 2: column: descr lowercase a ok 65 - nice_string test of row 2: column: descr lowercase a ok 66 - byte_string test of row 3: column: nch (uft8) lowercase b ok 67 - nice_string test of row 3: column: nch (uft8) lowercase b ok 68 - byte_string test of row 3: column: descr lowercase b ok 69 - nice_string test of row 3: column: descr lowercase b not ok 70 - byte_string test of row 4: column: nch (uft8) smiley face # Failed test 'byte_string test of row 4: column: nch (uft8) smiley face' # in t/nchar_test_lib.pl at line 341. # got: '38|58' # expected: '226|152|186' not ok 71 - nice_string test of row 4: column: nch (uft8) smiley face # Failed test 'nice_string test of row 4: column: nch (uft8) smiley face' # in t/nchar_test_lib.pl at line 344. # got: '&:' # expected: '\x{263A}' ok 72 - byte_string test of row 4: column: descr smiley face ok 73 - nice_string test of row 4: column: descr smiley face # row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58 ok 74 - number of rows fetched # Looks like you failed 4 tests of 74. [EMAIL PROTECTED] DBD-Oracle-1.17]# Has anyone ever encountered this error? Regards, Andrew Please do not transmit orders or instructions regarding a UBS account by e-mail. The information provided in this e-mail or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your e-mail. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you. UBS Financial Services Inc. UBS International Inc. Please do not transmit orders or instructions regarding a UBS account by e-mail. The information provided in this e-mail or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your e-mail. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you. UBS Financial Services Inc. UBS International Inc.
