Test t/24implicit_utf8.t fails when compiling DBD-Oracle-1.17

------_=_NextPart_001_01C67475.F7BA2E11
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

The following test is failing during make test:

[foo@bar DBD-Oracle-1.17]# perl -Mblib t/24implicit_utf8.t
--- testing implicit csform (dbhimp.c sets csform implicitly)
1..74
row: 1: nice_string=3D\x03 byte_string=3D3 (, '.')
row: 2: nice_string=3Da byte_string=3D97 (a, 'a')
row: 3: nice_string=3Db byte_string=3D98 (b, 'b')
row: 4: nice_string=3D\x{263A} byte_string=3D226|152|186 (âº, =
"âÂÂ=BA")
--- testing with NLS_NCHAR=3DUTF8
set $ENV{NLS_NCHAR}=3DUTF8
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=20
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=20
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=20
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=20
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) =3D Typ=3D1 Len=3D4: 0,38,0,58
ok 37 - number of rows fetched
--- testing with NLS_NCHAR=3DAL32UTF8
set $ENV{NLS_NCHAR}=3DAL32UTF8
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=20
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=20
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=20
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=20
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) =3D Typ=3D1 Len=3D4: 0,38,0,58
ok 74 - number of rows fetched
# Looks like you failed 4 tests of 74.

[foo@bar DBD-Oracle-1.17]#=20

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.


------_=_NextPart_001_01C67475.F7BA2E11--

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"
To:
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:

[foo@bar 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.

[foo@bar 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.

RE: Test t/24implicit_utf8.t fails when compiling DBD-Oracle-1.17

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:scoles@pythian.com]=20
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 =3D?
Oracle version =3D 9.2.0.4.0
Oracle Client =3D 9.2.0.4
DBI =3D1.5
DBD:Oracle =3D 1.17

Cheers.
John Scoles

----- Original Message -----
From: "Chen, Andrew"
To:
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:

[foo@bar DBD-Oracle-1.17]# perl -Mblib t/24implicit_utf8.t
--- testing implicit csform (dbhimp.c sets csform implicitly)
1..74
row: 1: nice_string=3D\x03 byte_string=3D3 (, '.')
row: 2: nice_string=3Da byte_string=3D97 (a, 'a')
row: 3: nice_string=3Db byte_string=3D98 (b, 'b')
row: 4: nice_string=3D\x{263A} byte_string=3D226|152|186 (âº, =
"âÂÂ=BA")
--- testing with NLS_NCHAR=3DUTF8
set $ENV{NLS_NCHAR}=3DUTF8
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) =3D Typ=3D1 Len=3D4: 0,38,0,58
ok 37 - number of rows fetched
--- testing with NLS_NCHAR=3DAL32UTF8
set $ENV{NLS_NCHAR}=3DAL32UTF8
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) =3D Typ=3D1 Len=3D4: 0,38,0,58
ok 74 - number of rows fetched
# Looks like you failed 4 tests of 74.

[foo@bar 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.

Re: Test t/24implicit_utf8.t fails when compiling DBD-Oracle-1.17

Ok I had some time today to look at it I unfortunately could not recreate
the error with my system

On my system my row 4 settings are

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.7.0 CHAR set is US7ASCII (Non-Unicode), NCHAR set is UTF8
(Unicode)
Client 10.2.0.1 NLS_LANG is '.WE8ISO8859P15', NLS_NCHAR is 'UTF8'

while your settings were

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'


So the exact error may be with you how DBD::Oracle was built with the
client. I would try rebuilding DBD::Oracle and use the

export NLS_LANG=.WE8ISO8859P15

before the build this may fix it.

I will try to recreate your system exactly next week if I can find a spare
DB around here to play with.

Cheers John Scoles

----- Original Message -----
From: "Chen, Andrew"
To: "John Scoles" ;
Cc: "Furman, Michael [Stability/Quality Assurance]"

Sent: Thursday, May 11, 2006 9:11 AM
Subject: RE: Test t/24implicit_utf8.t fails when compiling DBD-Oracle-1.17


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:scoles@pythian.com]
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"
To:
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:

[foo@bar 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.

[foo@bar 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.

Re: Test t/24implicit_utf8.t fails when compiling DBD-Oracle-1.17

On Fri, May 12, 2006 at 03:10:51PM -0400, John Scoles wrote:
> Ok I had some time today to look at it I unfortunately could not recreate
> the error with my system
>
> On my system my row 4 settings are
>
> 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.7.0 CHAR set is US7ASCII (Non-Unicode), NCHAR set is UTF8 (Unicode)

I recall something about UTF8 not being supported (by Oracle) as a *database* NCHAR charset.

Tim.

> Client 10.2.0.1 NLS_LANG is '.WE8ISO8859P15', NLS_NCHAR is 'UTF8'
>
> while your settings were
>
> 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'
>
>
> So the exact error may be with you how DBD::Oracle was built with the
> client. I would try rebuilding DBD::Oracle and use the
>
> export NLS_LANG=.WE8ISO8859P15
>
> before the build this may fix it.
>
> I will try to recreate your system exactly next week if I can find a spare
> DB around here to play with.
>
> Cheers John Scoles
>
> ----- Original Message -----
> From: "Chen, Andrew"
> To: "John Scoles" ;
> Cc: "Furman, Michael [Stability/Quality Assurance]"
>
> Sent: Thursday, May 11, 2006 9:11 AM
> Subject: RE: Test t/24implicit_utf8.t fails when compiling DBD-Oracle-1.17
>
>
> 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:scoles@pythian.com]
> 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"
> To:
> 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:
>
> [foo@bar 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.
>
> [foo@bar 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.
>
>