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.