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.

Re: JSP encoding problem

cichomitiko gmail

2006-06-18