OK... I tried saving the £ symbol into DB via java program as supposed to
psql command line and it works fine in saving/retreiving from DB ( via java
program)
But the issue here is, when I run the sql commands, it does not show me the
£ symbol in the returned query.. (some gibberish character) May be because
DOS prompt default CP is 437. Not sure what do I need to do in order to see
the £ symbol in the returned result set in running the queries or vewing
the data in the database.
testdb=> show server_encoding;
server_encoding
-----------------
UTF8
(1 row)
testdb=> set client_encoding = 'UTF8';
SET
testdb=> \encoding
UTF8
Select text from test;
*Get £500* // Actual ( Expected *Get £500* )
Not sure what the client_encoding and server_encoding does here?
Thanks,
Sai
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Reading-character-from-DB-is-displaying-character-tp5771897p5772120.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.