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.
>
>
