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.