> -----Original Message-----
> From: John Scoles [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 06, 2006 11:29 AM
> To: [email protected]
> Subject: Re: DBD::Oracle error when switching between utf8 and
non-utf8
>
> Well find a few things
>
> The windows error comes from the fact that I did not have Encode.pm
> installed so I fixed that and it runs.
>
> It also looks like this may be the old issue related to DBI not being
> fully compatible with UTF8 .
>
> Check out this link
>
> http://www.mhonarc.org/archive/html/perl-unicode/2003-12/msg00013.html
Perhaps. I'd be surprised if that was the case, though, because that
deals
with variables that DBI/DBD *create*.
This might help. This is what DBI->trace says when I bind the utf8
before ever
having bound a non-utf8:
rebinding :p1 with UTF8 value so setting csform=SQLCS_IMPLICIT
bind :p1 <== "X" (in, is-utf8, csid 1->0->871, ftype 1,
csform 0->2, maxlen 1, maxdata_size 0)
But when I've bound a non-utf8 to that statement before, this is what I
get
when binding utf8:
rebinding :p1 with UTF8 value so setting csform=SQLCS_IMPLICIT
bind :p1 <== "X" (in, is-utf8, csid 873->0->873, ftype 1,
csform 0->2, maxlen 1, maxdata_size 0)
I don't really know anything about OCI, so I can't interpret the
difference
between 1->0->871 and 873->0->873. Does that mean anything to you?
Thanks,
Philip