Thread: Problem : Pound to Hash sign

Hi there,

This is Sanjay from Dublin, Ireland.  I have a query related to JDBC.

In the web based application we have designed we have used Oracle 8i to
store the data and Java as a front end.

When a user enters some description against a field containing a '£' sign
and commits the record; it gets stored as a '#' sign and not the '£'.  I
think this problem may not be in Oracle's area as the same works fine when
record is being inserted through SQL or Pl/sql.

We tried to analyze where it actually get converted - The '£' sign leaves
unchanged from JSP, and again from Servlet and again unchanged from Bean.
From Bean it goes to JDBC.

Still we do not have clue where it gets converted into '#'.

Do we have to change any kind of settings ?  Kindly let me know the
solution if you can.

Thanks a lot.

Regards,
--Sanjay Dixit.

sanjay.dixit@nebula.ie writes:

> Hi there,
>
> This is Sanjay from Dublin, Ireland.  I have a query related to JDBC.
>
> In the web based application we have designed we have used Oracle 8i to
> store the data and Java as a front end.
>
> When a user enters some description against a field containing a '£' sign
> and commits the record; it gets stored as a '#' sign and not the '£'.  I
> think this problem may not be in Oracle's area as the same works fine when
> record is being inserted through SQL or Pl/sql.

This isn't an Oracle mailing list.  Call your Oracle support line.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863