Hi John, (added to JDBC list)
1. What is your database encoding? Does it support the unicode OK?
2. Are you sure it's getting /stored/ as a question mark rather than just displayed as such? Remember, if it is stored correctly, but you look at it from a terminal that doesn't support the character, you might be seeing an artifact of your terminal, not the underlying representation.
I would suggest you try having the cent symbol pulled in via the normal route, and once it's in a java.lang.String, have java pop open a JOptionPane.showMessageDialog and show you what it thinks the String is. If it's not showing you the right character here, then the problem is way upstream of Postgres. If it displays OK here, have Java pull the value back out of the database and show it in another messageDialog; my guess is you'll see one of three things:
A. Neither dialog shows the unicode OK. This means you have some encoding/decoding issues upstream of Postgres.
B. The first dialog is OK, the second is not. Probably, your encoding for the database is not set right.
C. Both dialogs are OK. The problem is merely an artifact of how you're seeing the unicode stuff, not a Java + Postgres problem.
Best,
Randall
On Tuesday, May 13, 2003, at 01:18 PM, jwang wrote:
Hi All,
I have a web application in JSP/Servlet/PostgreSQL(7.3). I have a text input field where users can enter special cent symbol to represent cent unit just like dollar symbol. So I have to use java.net.URLDecoder.encode(text_input,"UTF-8") to fetch the request input on the server.
If I just insert the encoding text into the database, it will store the
text in URL-encoding format. But I want to store text in ASCII-readable
format (and cent symbol is stored just like dollar symbol), rather then
in URL-encoding format. If I am using
java.net.URLDecoder.decode(text_input,"UTF-8") to decode the text before
I do inserting, the cent symbol is stored as a question mark symbol in
database. I tried to find a postgres encoding function without success.
Does anyone know what the problem is and how to solve it?
Thanks a lot.
-John
GSP Marketing Technologies, Inc. [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
