I export the following vars: ORACLE_HOME=/opt/app/oracle/product/9.2.0 PATH=/usr/local/bin:$ORACLE_HOME/bin:$PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib ORACLE_USERID='<userid>/<pass>@<SID>'
#NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
NLS_LANG=.WE8ISO8859P1
NLS_NCHAR=AL16UTF16
export ORACLE_HOME PATH LD_LIBRARY_PATH NLS_LANG NLS_NCHAR ORACLE_USERID
I get the same failure with NLS_LANG set to either value above.
1.) `make test` fails at the same place (see attached output).
2.) # 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 '.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 '.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.
Thanks,
Andrew
-----Original Message-----
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Friday, May 12, 2006 5:28 PM
To: John Scoles
Cc: Chen, Andrew; dbi-users@perl.org; Furman, Michael [Stability/Quality
Assurance]
Subject: 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" <[EMAIL PROTECTED]>
> To: "John Scoles" <[EMAIL PROTECTED]>; <dbi-users@perl.org>
> Cc: "Furman, Michael [Stability/Quality Assurance]"
> <[EMAIL PROTECTED]>
> 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:[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.
>
>
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.
make_test.out.1.gz
Description: Binary data
