Re: JSP encoding problem

Last attempt :)

It seems that this is multibyte garbage - nullbytes (perhaps Unicode 16-bit charaters) - when selecting from remote database (Oracle 8.1.7.4) via http/jsp (the Oracle Applications /administration/status/sqlEngine.jsp) I've tried to get rid of them with to_single_byte/convert to different character sets with no luck.

Does anyone know how I can turn this (where ^@ = nullbyte):

^@C^@O^@A^@D^@M^@8^@2^@0^@8^@^I^@2^@7^@3^@1^@2^@8^@^I^@

Into this:

COADM8208 273128 in sql?

Thanks
Dimitre

  iAS 9i r1 (1.0.2.2.) + Oracle Portal 3.0.9.8.0   Solaris 8
  Oracle Database Server 8.1.7.4

  Custom JSP suddenly stops working and in the custom application log we see some "strange" characters.

1. Before the problem occurred:

  QuerySubmissionEngine.doQuery(): results = UPPER(USER_NAME) CUSTOMER_ID

  2. After:

  QuerySubmissionEngine.doQuery(): results = ’žUPPER(PARTY_NAME) PARTY_ID

  Output from cat -vt:

1. Before the problem occurred:

  COADM1921^I22656^I
  COADM1922^I22657^I   2. After:

^@C^@O^@A^@D^@M^@8^@2^@0^@8^@^I^@2^@7^@3^@1^@2^@8^@^I^@
^@C^@O^@A^@D^@M^@8^@2^@0^@9^@^I^@2^@7^@3^@1^@3^@1^@^I^@

  The same JSP still works in developement.

--
http://www.freelists.org/webpage/oracle-l