On Thu, Dec 29, 2005 at 11:56:27AM +0100, Honza Pazdziora wrote: > > case 96: /* CHAR */ > fbh->disize = fbh->dbsize; > if (CS_IS_UTF8(fbh->csid)) > fbh->disize = fbh->dbsize * 4; > fbh->prec = fbh->disize; > break; > > but on a database with character set EE8ISO8859P2 (single byte) and > with NLS_LANG=AMERICAN_AMERICA.UTF8, the > > ORA-24345: A Truncation or null fetch error occurred (DBD ERROR: > ORA-01406 error on field 1 of 98, ora_type 1) > > is still there. If I remove the > > if (CS_IS_UTF8(fbh->csid)) > > line and just multiply the disize by four for all CHARs, the fetch works. > > If I understand that CS_IS_UTF8 macro correctly, it compares fbh->csid > to utf8_csid or to al32utf8_csid. However, for my column (database > in EE8ISO8859P2, NLS_LANG=AMERICAN_AMERICA.UTF8), the trace shows > > col 1: dbtype 1, scale 0, prec 80, nullok 0, name ID_FIR > : dbsize 20, char_used 0, char_size 20, csid 32, csform 1, disize 80 > > where csid 32 seems to be the id of (server's) EE8ISO8859P2, not > of client's UTF8. So the CS_IS_UTF8(fbh->csid) evaluates to false, > the buffer is not extended and fetching data from single byte database > to UTF8 client fails.
> Any idea what should I try next to make CS_IS_UTF8 (and fbh->csid) > behave like it is supposed to? I think it only needs to *4 if the _client_ csid is utf8. Try the attached. If that works then I think similar logic is needed for NCHAR. Could you reproduce the problem using an NCHAR field with your client NCHAR charset set to utf8 and your non-nchar charset set to an 8bit charset? Tim.
Index: oci8.c =================================================================== --- oci8.c (revision 2342) +++ oci8.c (working copy) @@ -1223,7 +1223,7 @@ /* FALLTHRU */ case 96: /* CHAR */ fbh->disize = fbh->dbsize; - if (CS_IS_UTF8(fbh->csid)) + if (CS_IS_UTF8(csid)) fbh->disize = fbh->dbsize * 4; fbh->prec = fbh->disize; break; @@ -1249,7 +1249,7 @@ break; case 8: /* LONG */ - if (CS_IS_UTF8(fbh->csid)) + if (CS_IS_UTF8(csid)) fbh->disize = long_readlen * 4; else fbh->disize = long_readlen;