Problem : Pound to Hash sign - Mailing list pgsql-general

From sanjay.dixit@nebula.ie
Subject Problem : Pound to Hash sign
Date
Msg-id OF6575B916.4777F73F-ON80256AE1.003E0059@nebula.ie
Whole thread Raw
List pgsql-general
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.






pgsql-general by date:

Previous
From: Eric D Nielsen
Date:
Subject: Problems install with Python...
Next
From: "H. Wade Minter"
Date:
Subject: Where to count